COUNTA and the old ZERO

RayD · Oct 14, 2003

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 · Oct 14, 2003

One way:

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

Dan E · Oct 14, 2003

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

Dan E

RayD · Oct 14, 2003

Many thanks to all.. that did the trick!

One way:

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

RayD · Oct 14, 2003

Many thanks to all.. that did the trick!

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

Dan E