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?

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

I must have tried everything but that one! Thanks ever so much Humar!

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History