when field contains

[Tammy]

Hi smart people -

I have a list I'm trying to wade through.

What I need is the command to countif whatever street name is in the field;
and I'm not looking for matches throughout the whole field, only where the
street name is contained in the field. Does that make sense?
Thanks!
Tammy

 

[Bob Phillips]

=COUNTIF(A:A,"*streetname*")

 

[rpal]

hi

Assuming streetname (criteria) to be searched is in cell C2 and the
range to be looked up is full column A, the following formula is
placed in cell D2:

COUNTIF(A:A,"*"&TEXT(C2,"general")&"*")

If street name is "pal", u may also use sthg like:

=COUNTIF(A:A,"*pal*")

But the first one is more flexible and recommended.

Let me know if this was found helpful.

Pal.