Count Unique Values with Multiple Criteria

[jws]

Hello,

I have this formula to give me the number of unique locations and it works fine for cell J1:

=SUM(IF(FREQUENCY(MATCH($B$3:$B$22,$B$3:$B$22,0),MATCH($B$3:$B$22,$B$3:$B$22,0))>0,1))

What I am trying to figure out is how to populate cells N4:N5 and N8:N9 for unique locations by Fruit & Vegtables by Area A and Area B. I just have some basic data for this example as the spreadsheets are 30,000+ lines long.

Hopefully my request is clear, if not please let me know.

Thanks

 

[Matty]

Try:

=SUM(IF(FREQUENCY(IF(A$2:A$21=K4,MATCH(B$2:B$21,B$2:B$21,0)),ROW(B$2:B$21)-ROW(B$2)+1),1))

Array entered in N4 and copied down.

Matty

 

[jws]

Solved

Thank you!