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!