L
lothar
I am wanting to sum a set of numbers for the previous 7 days. I am using the
following formula:
=SUM(($A4>=$A$2:$A$400)*($A$2:$A$400>$A4-7)*($C$2:$C$400))
When I look at the Function Arguments window it shows "Formula result =
214.5" (the correct value) but it displays "67.2" (the daily value) in the
spreadsheet.
Does anyone know what is going on and how to remedy it?
following formula:
=SUM(($A4>=$A$2:$A$400)*($A$2:$A$400>$A4-7)*($C$2:$C$400))
When I look at the Function Arguments window it shows "Formula result =
214.5" (the correct value) but it displays "67.2" (the daily value) in the
spreadsheet.
Does anyone know what is going on and how to remedy it?