Announcement

Collapse
No announcement yet.

SUMPRODUCT on 1 column and criteria on another columns

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!
Working...
X