Countifs matching two separate tables

[Melimob]

Hi

I have this formula but stuck on the last condition.

I want to count based on Client Name in current table where it finds a match to:
table1 client name
& is not OOS/Lost
AND
if the country is listed both on table1 matching a table in another sheet which is called 'Prority 1'

this last bit is where I'm stuck? Grateful for advice! thank you!

=COUNTIFS(Table1[POA / Clients],"*"&[Client Name]&"*",Table1[OOS / Lost],"<>OOS",Table1[OOS / Lost],"<>LOST",Table1[Country],Priority_1)

 

[Marcelo Branco]

Unfortunately that didn't work

It worked perfectly for me.
What you mean by didn't work? Error? Wrong result?

M.