Count unique text values with Multiple criteria

[Bselan]

Hello,

I have a data set that has Materials (column A) assigned to a product group (column E), product groups could be part of multiple Product Specification (PS, column G) and these items are built in multiple configuration (column C)

I am trying to count the total number of unique configurations (C) for a given Product group (e) and Product spec (G); counting text values vs numeric values...

I am currently using (column D) =SUMPRODUCT(--(FREQUENCY(IF($E$5:$E$7278=E5,IF($G$5:$G$7278=G5,MATCH($H$5:$H$7278,$H$5:$H$7278,0))),ROW($H$5:$H$7278)-ROW(H5)+1)>0))

which works most of the time...
When filtering on column E for ACCESSORIES GLOBAL & column G PS1000183, it returns 1 which is correct
When filtering on column E for ACCESSORIES GLOBAL & column G PS1000184, it returns 2 which is correct
When filtering on column E for SH MITRACLIP NT CE & column G PS1014342, some rows return 2 (correct) some rows return 1 (incorrect)

Is there a row limitation on this formula, will it not calculate 7278 rows?

Not sure how to share the file but I can give two screen shots of my issue

Any help would be appreciated!!!

Thank you!

 

[jasonb75]

The only anomaly that I can see is the last row reference being relative instead of absolute

=SUMPRODUCT(--(FREQUENCY(IF($E$5:$E$7278=E5,IF($G$5:$G$7278=G5,MATCH($H$5:$H$7278,$H$5:$H$7278,0))),ROW($H$5:$H$7278)-ROW($H$5)+1)>0))

With a relative reference at that point the bins array of frequency would not be aligned with the data array as expected.