count unique occurences with two criteria

[dark11984]

Hi I'm trying to count unique occurences of a column when two other columns meet the criteria. The formula i'm trying to get to work is below but I keep getting a #N/A. Can anyone help?

=SUM(IF(FREQUENCY(IF(RED_Delivery_Query!$I$2:$I$2200<>"",IF(RED_Delivery_Query!$D$2:$D$2200=$C4,
   IF((RED_Delivery_Query!$H$2:$H$2200=H$3),
    MATCH("~"&RED_Delivery_Query!$I$2:$I$2200&"",0)))),
     ROW(RED_Delivery_Query!$I$2:$I$2200)-ROW(RED_Delivery_Query!$I$2)+1),1))

Thanks

 

[Aladin Akyurek]

Try...

=SUM(IF(FREQUENCY(IF(RED_Delivery_Query!$I$2:$I$2200<>"",
    IF(RED_Delivery_Query!$D$2:$D$2200=$C4,
    IF(RED_Delivery_Query!$H$2:$H$2200=H$3,
     MATCH("~"&RED_Delivery_Query!$I$2:$I$2200,
       RED_Delivery_Query!$I$2:$I$2200&"",0)))),
     ROW(RED_Delivery_Query!$I$2:$I$2200)-
       ROW(RED_Delivery_Query!$I$2)+1),1))