COUNTA and the old ZERO

[RayD]

Good morning,

=COUNTA(E8:E372)

Is there a smooth way to "NOT" have this formula to return a 0 if all
cells in the range are empty?

 

[J.E. McGimpsey]

One way:

=IF(COUNTA(E8:E372),COUNTA(E8:E372),"")

 

[Dan E]

=IF(COUNTA(E8:E372)=0,"",COUNTA(E8:E372))

Dan E

 

[RayD]

Many thanks to all.. that did the trick!

One way:

=IF(COUNTA(E8:E372),COUNTA(E8:E372),"")

 

[RayD]

Many thanks to all.. that did the trick!

=IF(COUNTA(E8:E372)=0,"",COUNTA(E8:E372))

Dan E