Count function
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!
|