Countif not blank

Darby · Sep 7, 2005

I would like to count a the number of cells in a range that are not blank.
=countif(a1:a14,"<>""") includes blank cells in its results.

I checked to see if the cells were actually blank by using
=countif(a1:a14,""),which counted the blank cells correctly.

Anybody got any ideas?

Thanks

CLR · Sep 7, 2005

=COUNTA(A1:A14)

Vaya con Dios,
Chuck, CABGx3

David Billigmeier · Sep 7, 2005

You're close:

=COUNTIF(A1:A14,"<>"&"")

Darby · Sep 7, 2005

Thanks, works like a charm

David Billigmeier said:
You're close:

=COUNTIF(A1:A14,"<>"&"")

Countif not blank

Darby

CLR

David Billigmeier

Darby