Count function
COUNT works only on numbers.
=COUNTA(range) will count all cells...........text or numeric
If you had a mix of numeric and text cells in the range
=COUNTA(B2:B33)-COUNT(B2:B33) would return only text cells.
Gord Dibben MS Excel MVP
On Tue, 23 Jun 2009 09:33:01 -0700, H wrote:
I have in Several Columns a list of Customer Names and for each column I
would like to do a Count of how many in each column but when I do
=Count(B2:B33)
it returns a 0 and should return 4
Does a Count not work on text?
Thanks!
|