• Status: Solved
• Priority: Medium
• Security: Public
• Views: 174

# Excel - Why isn't this formula working?

Hi Excel Experts,

How come this formula works in one of my workbooks but not another?

Combined-Inventory-09-30-10-New.xlsx Combined-Inventory--August-2011-.xlsx

I am trying to do a fairly simple formula:  =SUM((\$C\$4:\$C\$1272=\$C\$1275)*(\$Q\$4:\$Q\$1272))

Whenever I put it in, i get #Value.

Why?
0
activematx
1 Solution

Commented:
That's an "array formula" - you need to enter it and then confirm with CTRL+SHIFT+ENTER

To do that press F2 key to select formula then hold down CTRL and SHIFT keys and press ENTER so that curly braces like { and } appear around the formula in the formula bar.

It's simpler, though, in this case to use a non-array SUMIF formula to get the same result, i.e.

=SUMIF(\$C\$4:\$C\$1272,\$C\$1275,\$Q\$4:\$Q\$1272)

regards, barry
0

Author Commented:
Thanks so much Barry!  You saved me so much time!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.