Counting text in a column
Yes. Isn't it strange that COUNTBLANK and ISBLANK have different ways of
treating the empty string ""?
--
David Biddulph
"Bob Phillips" wrote in message
...
=COUNTA(M2:M20)-COUNTBLANK(M2:M20)
--
__________________________________
HTH
Bob
"Paul H" wrote in message
...
I would like to count the text in a column, (each text would count as 1),
the
column contains a simple "If" statement that will return either a name or
a
blank. The text counting solutions I see in these posts also count the
If
statement as 1.
|