How to manage a SumIf

nmck86,

Would you please give us an example and desired result so we can better understand your exact requirement?

----->I cant multiply the values because it distorts the NPS because some of the 9s could move from promotors to detractors

Since you have to consider the weights which have an effect on real score, what’s the stand of score range to distinguish   DETRACTORS, PASSIVES, and PROMOTERS?

For example, if the score of one customer is 9 and the weight is 0.8, multiply the value then the real score is 7.2. Personally, this result should be sensible if you can believe the weight . If not, please share the standard of the real score.

Regards,

Pirlo Zhang