Hiding contents of a column

[JK]

A simple spread sheet formula'd to add across and give a total

I want that total added to a final total obviously in the same column.

This produces an entry in every row of that column, even when there is
no total (0.00).

Can I hide that default entry?

 

[JK]

Thank you. Of course every cell has an entry. Your formula - where
is it enetered please?

 

[Don Guillett]

If you can post your formula (NOT workbook) for comments. No mindreaders
here.

 

[JK]

=SUM(E5:E48)

Of course this idiot simple formula should cause no problems to the
experts, not even to meat my level! Attching your formula is the
problem. Sorting it will no doubt hold me in good stead for the
future.

 

[Thomas]

=if(SUM(E5:E48)=0,"",SUM(E5:E48))
is what you're looking for?