when field contains

T

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
 
R

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.
 
Top