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?
Thanks
Code:
=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