want to erase the 0
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

want to erase the 0
 

Try,

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

Mike

"Darrell_Sarrasin via OfficeKB.com" wrote:

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

want to erase the 0
 

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?

Mike H wrote:
Try,

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

Mike

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

want to erase the 0
 

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

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8a47b556100c5@uwe...
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?

Mike H wrote:
Try,

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

Mike

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

want to erase the 0
 

=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.

"Darrell_Sarrasin via OfficeKB.com" wrote:

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?

Mike H wrote:
Try,

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

Mike

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1

--

Dave Peterson