Change formula from SUMIFS to Count Unique

[03856me]

I have this formula written which actually does what I am asking it to do, but what I need is this formula changed to count only the unique "unit numb" fields in the dataTable based on the criteria I have listed. Can someone point me in the right direction:

=SUMIFS(dataTable[unit numb],dataTable[mill],"TLC",dataTable[specie],"Hem-O",dataTable[grade],"Econ",dataTable[size],"2x6",dataTable[length],"12")

 

[03856me]

Figured it out:

=SUM(IF(FREQUENCY(IF(dataTable[mill]=S1,IF(dataTable[grade]=S3,IF(dataTable[size]=S2,IF(dataTable[length]=S4,dataTable[unit numb])))),dataTable[unit numb]),1))

then CTRL ALT DELETE

wanted to share since I have seen a lot of posts like this but no solutions