I'm not quite sure what I need to do for this to work. The ranges i gave in
the original post have various text in all the cells. Are you saying I need
to enter a list of something in certain cells? Can you please give me a
little more of a step-by-step on this? I've never even heard of DCOUNTA
before, let alone used it.

Thanks!
Mike

"Ron Coderre" wrote:

Another possibilty....DCOUNTA?

With
N16:N120 contains your first list, with List_1 in N16
S16:S120 contains your second list, with List_2 in S16

K1: List_1
K2: EP

L1: List_2
L2: *migrate*

M1: =DCOUNTA(N16:S120,"List_1",K1:L2)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"WiFiMike2006" wrote:

Hello,

I am trying to create a formula that will count the number of cells with
certain text (EP) in one range that also have an instance of certain wildcard
text (*migrate*) in another range in the same row.

For example, this is the formula I'm using, but it doesn't seem to work, and
I need to know what I should use instead:

=COUNT(IF((N17:N120="EP")*(S17:S120="*migrate*"),0 ))

However, the formula works if it looks like this (wildcard text not used for
"migrate"):

=COUNT(IF((N16:N101="EF")*(S16:S101="migrate"),0))

But, the reason I need to use the wildcard text is that sometimes the text
in S16:S101 will be changed to "migrated" or "replaced & migrated", which
throws off the count resulting from the formula.

Is there a way to do this with a different function or formula? Apparently,
the wildcard text thing only seems to work for criteria in simpler formulas
like this one:

=COUNTIF($O$16:$O$105, "*SWM*")

Any help would be greatly appreciated. I've spent hours trying to figure
this one out.

Thank you!

Mike