How to hide the function cell when there is no value in the referenced cell

J

jim

I have a sheet with a number of columns with a "total" row at the bottom.
If there are no values to sum then the total cell displays a "0". Is it
possible to have the cells in the "total" row not display anything until a
value is entered in the respecive referenced cells?

Thanks,

Jim
 
D

Dan E

=IF(ABS(SUM(E1:E10)) > 0, SUM(E1:E10), "")

where E1:E10 is the values im summing

Dan E
 
A

Andy

jim

Put the sum in an IF statement.
If it was =SUM(A2:A25), replace that with =IF(SUM(A2:A25)<>0,SUM(A2:A25),"")

Andy
 
J

J.E. McGimpsey

This will hide sums of zero in situations where values of, say,
-100, 20 and 80 are entered in E1:E3. A more robust way:

=IF(COUNT(E1:E10),SUM(E1:E10,"")
 
Top