A B C D E F
2 S1 S2 Weight
3 C1 2 -1 5
4 C2 1 -2 1
5 C3 0 -2 5
6 C4 -1 1 3
7 Weighted Sum of Positives
8 Weighted Sum of Negatives
Pugh.jpg
Hi, I am trying to calculate the weighted sum of positives and negatives in the attached spreadsheet. The value in D7 should be 11 (2*5+1*1) and in D8 should be -3. I've tried SUMIF, SUMPRODUCT, PRODUCT(IF..) with no success so I must be doing something wrong. Thanks for your help!!
Bookmarks