Modify filter function to include multiple criteria

[Anglais428v2]

Hi,
I have a formula that works:
=COUNTA(UNIQUE(FILTER(Country,ISNUMBER(MATCH(Sector,{"A","B"},0)))))

I want to add a further criteria search (i.e. effectively copying what is being performed in the ISNUMBER(MATCH(Sector,{"A","B"},0) part but for a different column (Industry) and different search criteria (C and D, instead of A and B)

 

[Fluff]

Do both columns need to match or either one?

 

[Anglais428v2]

Both columns need to match. So i was thinking something like the below, but it isn't working:
=COUNTA(UNIQUE(FILTER(Country,ISNUMBER(MATCH(Sector,{"A","B"},0)))*FILTER(Country,ISNUMBER(MATCH(Industry,{"C","D"},0)))))

 

[Fluff]

Ok, how about

=ROWS(UNIQUE(FILTER(Country,(ISNUMBER(MATCH(Sector,{"A","B"},0)))*(ISNUMBER(MATCH(Industry,{"C","D"},0))))))

 

[Anglais428v2]

Perfect. Many thanks!

 

[Fluff]

You're welcome & thanks for the feedback.