Formula result does not match displayed result

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?
 
M

Max

=SUM(($A4>=$A$2:$A$400)*($A$2:$A$400>$A4-7)*($C$2:$C$400))
Your formula above is an array formula, which needs to be array-entered.
Click inside the formula bar, then press CTRL+SHIFT+ENTER (CSE) to confirm
the formula. If you do it correctly, you'd see Excel wrap curly braces: { }
around your formula in the formula bar.

In this instance, alternatively you could use:
=SUMPRODUCT(($A4>=$A$2:$A$400)*($A$2:$A$400>$A4-7)*($C$2:$C$400))
which can be normally entered, is just press ENTER to confirm the formula
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top