# 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=1The formula returns 1? See More: Excel Problem - SUMIF Question

#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+EnterIf so, this is rarely required.Array formulas are rather specialized and most routine calculations do not need them.RegardsHumar

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 