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????