Would like autosum cell to show blank

[Arfon]

Hi.
A bit of help please.....

I have cell I3 which is an Autosum of cells B3 to H3. Though nothing is populated in B3-H3 currently, I3 still shows 0.00.
However I would like I3 to show nothing until B3-H3 is populated.

Any views please?
thanks
Arfon

 

[AlanY]

try

=if(sum(B3:H3)=0,"",sum(B3:H3))

 

[BobUmlas]

=IF(COUNT(B3:H3)=0,"",SUM(B3:H3))
or just format cell I3 as "0.00_);(0.00);" (no quotes

 

[BobUmlas]

If B3 has 3 and C3 has -3, you'd show nothing in I3 with your formula, where I think the user would want to see the 0.00

 

[AlanY]

If B3 has 3 and C3 has -3, you'd show nothing in I3 with your formula, where I think the user would want to see the 0.00

good point, it would work with -ve nos

 

[Arfon]

Hi Alan

Thanks for a quick reply. All systems GO.

cheers