Thank you all for your quick response. I wish I understood the formulas
more...



"PCLIVE" wrote:

This says that if the sum of cells A1 through A10 equals zero, then return
nothing ( "" ), else return the sum of A1 through A10.

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

HTH,
Paul

--

"MrReeLady" wrote in message
...
I'm still relatively new to the formulas - can't do anything too complex
yet
so this should be an easy one for all you experts out there.

I have cells that have basic Sum formula. If there is no value in any of
the preceding cells, the total cell shows $0.

I believe I can create a formula that says if the value is 0 then leave
blank. I don't want to see the $0.

Thanks!