zero for answer

[alfonsoto1]

I am summing rows with this formula =SUM(B2:B94) when all of the cells are blank my answer is 0, is there any way to leave the answer blank instead of showing 0?

 

[Fluff]

How about
=IF(SUM(B2:B94)=0,"",SUM(B2:B94))

 

[alfonsoto1]

Thanks Fluff, it works fine.

 

[Fluff]

You're welcome & thanks for the feedback