count formula for unique ids that meet multiple criteria

hello,

my table looks like this:

table 1.PNG


i would like to use formulas to count the number of unique ids, based on org and recognition type. end result would look like this:

table 2.PNG

notice that id Z0044444, in org SHS SP, is only counted once in the point based reward column, even though this id received two separate awards. i only want it counted once. same with id Z0088888, in org SHS MM, in the point based reward to my direct reports column.

i've tried COUNTIFS combined with a SUMPRODUCT but that doesn't seem to be doing the trick. thank you in advance for any tips.

sample workbook now attached. sorry about that.

Headers must be the same as in the file
attached.

The headers in your file did not have a "-".

I copied and pasted them from the table.



F2=IF($E2<>"",SUM(IF(FREQUENCY(IF($B$2:$B$100=$E2,IF($C$2:$C$100=F$1,MATCH($A$2:$A$100&$B$2:$B$100,$A$2:$A$100&$B$2:$B$100,0))),ROW($A$2:$A$100)-ROW($A$2)+1),1)),"")


Control+shift+enter

copy down