sum of blank cells returns zeros
Hi
=IF(SUM(--ISBLANK(B6:E6))0,"",SUM(B6:E6))
, entered as an array formula (Ctrl+Shift+Enter)
Or
=IF(OR(B6="",C6="",D6="",E6=""),"",SUM(B6:E6))
, entered in usual way (non-array formula)
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
"Mar_W" wrote in message
...
Hi, I'm trying to put a simple formula in excel to add up some cells - the
trouble is when the cells are blank, excel still calculates it as a zero.
I
know I can use the following to ignore the blanks
-=IF(SUM(B6:E6)=0,"",SUM(B6:E6))- but sometimes cells B6 to E6 might
contain
true zero scores. I've also tried using
if(isblank(sum(B6:E6)),"",(SUM(B6:E6))) but again it still returns zero.
You'd think it would be something simple but I can't see it and it's
driving
me mad!!!!
Can anyone out there help????
|