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?

=IF(C13:C20=0,"",C13:C20)

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.

Thus:

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 •


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

Hi,

As you want to test the sum of the cells in the range C13:C20 you have to specifically ask for the sum:
=IF(SUM(C13:C20)=0,"",SUM(C13:C20))

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.

Regards
Humar


Report •

#2
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