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

[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

 

[Dan E]

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

where E1:E10 is the values im summing

Dan E

 

[Chip Pearson]

Jim,

Try something like

=IF(SUM(A1:A100)=0,"",SUM(A1:A100))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[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.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,"")