ExcelBanter - Countif not blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Countif not blank (https://www.excelbanter.com/excel-worksheet-functions/44316-countif-not-blank.html)

Darby

Countif not blank

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

=COUNTA(A1:A14)

Vaya con Dios,
Chuck, CABGx3

"Darby" wrote:

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

David Billigmeier

You're close:

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

--
Regards,
Dave

"Darby" wrote:

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

Darby

Thanks, works like a charm

"David Billigmeier" wrote:

You're close:

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

--
Regards,
Dave

"Darby" wrote:

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

All times are GMT +1. The time now is 05:43 PM.