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

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History