Nel post
*Mar_W* ha scritto:

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


Hi Mar_W

try this one:

=IF(COUNTA(B6:E6),SUM(IF(B6:E6<"",B6:E6,"")),"")

array entered, i.e. with Ctrl+Shift+Enter instead of Enter.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy