Count if cell contains a comma

F

Fred Smith

I want to count the cells which contain a comma. Is it possible to do
something like:

=COUNTIF(B2:B53,FIND(",",B2:B53)>0)
 
R

Ron Rosenfeld

I want to count the cells which contain a comma. Is it possible to do
something like:

=COUNTIF(B2:B53,FIND(",",B2:B53)>0)
Click to expand...


=COUNTIF(B2:B53,"*,*")


--ron
 
R

Ron Rosenfeld

I want to count the cells which contain a comma. Is it possible to do
something like:

=COUNTIF(B2:B53,FIND(",",B2:B53)>0)
Click to expand...


Note that my reply only works for text fields that contain commas. It will not
work for numeric fields that are formatted to show a comma.


--ron
 
F

Fred Smith

Hi Ron,

This is exactly what I was looking for. I want to search text fields, not
formatted numbers.

Just in case Microsoft monitors this group, Help could be improved because I
checked on the definition of "criteria" but never found that you could use
wild cards in them. It would have been a reasonable guess, but it's too easy
to post a question to the group.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


 
Top