Count if cell contains a comma

[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)

 

[bdcrisp]

=COUNTIF(B2:B300,",")

Try this out

 

[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)

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


--ron

 

[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)

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

 

[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