Excel Problem - SUMIF Question

Microsoft Office 2007 professional (aca...
February 6, 2010 at 14:25:27
Specs: Windows Vista
Can anyone explain why the following formula doesn't work?


The cell remains blank if value is zero, which is great. However, it only returns the value of C20 instead of adding the range C13:C20.


If C13 = 1, C14=2, C15=2, C16=1, C17=6, C18=2, C19=2, C20=1

The formula returns 1?

See More: Excel Problem - SUMIF Question

Report •

February 6, 2010 at 14:32:40
Response from Humar moved from a different thread...


As you want to test the sum of the cells in the range C13:C20 you have to specifically ask for the sum:

By the way did you enter this as an array formula using Ctrl+Shift+Enter
If so, this is rarely required.
Array formulas are rather specialized and most routine calculations do not need them.


Report •

February 6, 2010 at 16:37:04
I must have tried everything but that one!

Thanks ever so much Humar!

Report •

Related Solutions

Ask Question