SUMPRODUCT on 1 column and criteria on another columns

  • I have this formula but it will find unique value from only that range. How can I find unique value from another column base on that SUMPRODUCT function?


    =SUMPRODUCT(--(Table2[Customer Type]="KEY"),--(Table2[SO Status]="Pending"),--(Table2[Time]=230) give me 97 unique values


    I want to find unique value on Table2[CustomerNumber] based on above criteria.


    Thank you!