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!

Hi,

=Counta(B2:B33)

if this helps please click yes, thanks

"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!

perfect :) Thank you
"Eduardo" wrote:

Hi,

=Counta(B2:B33)

if this helps please click yes, thanks

"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!

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!

Hi,

You can also use

COUNTIF(B1:B20,"<")

for all non-empty cells

COUNTIF(B1:B20,"*")

for all text entries (excluding numbers)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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!