count the unique values with 2 condition

If collect formulas that could be couple of regular (non-array) ones like

=SUM(INDEX(($B$2:$B$8=F4)*($C$2:$C$8=G4)*1/COUNTIF($A$2:$A$8,$A$2:$A$8),0,1))

and

=SUMPRODUCT(($B$2:$B$8=F8)/COUNTIF($A$2:$A$8,$A$2:$A$8))

Please see attached

Hi, to both!

Another approach could be (in Matt's File) - [Both Formulas need enter with CSE Ctrl + Shift + Enter]

[H3] : =COUNT(1/FREQUENCY(IF((B2:B8=F4)*(C2:C8=G4),A2:A8),A2:A8))

[G8] : =COUNT(1/FREQUENCY(IF((B2:B8=F8),A2:A8),A2:A8))

Blessings!

Maybe try using an array formula like the below (see attached .xlsx for reference):

Confirm with CTRL + SHIFT + ENTER