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!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!