want to erase the 0

[Darrell_Sarrasin via OfficeKB.com]

I have a excel document that has a simple formula that adds three cells. A1,
A2, and A3. if blank if gives me a 0.00 in A4. I want it to return the cell
blank if there is nothing filled in for the three cells.

Thanks

 

[Mike H]

Try,

=IF(COUNTA(A1:A3)>0,SUM(A1:A3),"")

Mike

 

[Darrell_Sarrasin via OfficeKB.com]

thanks that worked great but now I have a second one that i am trying it with.
I have the answers below repeated for 11 rows to give me totals then I have a
grand total

if I do =if(COUNTA(A4:A14)>0,SUM(A4:A14),"") it comes out with 0 as I use the
others to create the total. Any thoughts to that?

 

[David Biddulph]

Try COUNT, rather than COUNTA, and then it won't count the text strings
(including the empty text strings).

 

[Dave Peterson]

=counta() will count non-empty cells--even cells that contain formulas that
evaluate to an empty string ("").

Maybe you want to use
=if(count(a4:a14)>0, ....

=count() only counts numbers.