Thread
:
Alpha & Numeric Counts in Excel
View Single Post
#
3
Harlan Grove
Posts: n/a
"CLR" wrote...
=COUNTA(A1:A6) results as 6
=COUNT(A1:A6) results as 4
=COUNTA(A1:A6)-COUNT(A1:A6) results as 2
....
FWIW, the last formula could be replaced by
=COUNTIF(A1:A6,"*")
Reply With Quote