SumProduct

[Manny74]

How would I use a Sumproduct to calculate V7, W7, X7 &Z7? (For April)

I was able to use the Sumproduct for Jan, Feb, March, but am having trouble including April...


[TABLE="width: 256"]
<tbody>[TR]
[TD="width: 21, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]

V​

[/TD]
[TD="width: 64, bgcolor: transparent"]

W​

[/TD]
[TD="width: 64"]

X​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Y​

[/TD]
[TD="width: 64, bgcolor: transparent"]

Z​

[/TD]
[/TR]
[TR]
[TD="width: 21, bgcolor: transparent"][/TD]
[TD="width: 64"]

Jan​

[/TD]
[TD="width: 64"]

Feb​

[/TD]
[TD="width: 64"]

Mar​

[/TD]
[TD="width: 64"]

Q1​

[/TD]
[TD="width: 64"]

Apr
​

[/TD]
[/TR]
[TR]
[TD="width: 21, bgcolor: transparent"]

7​

[/TD]
[TD="width: 64"]

57.60%​

[/TD]
[TD="width: 64"]

73.90%​

[/TD]
[TD="width: 64"]

74.70%​

[/TD]
[TD="width: 64"]

69.51%​

[/TD]
[TD="width: 64"]

71.40%​

[/TD]
[/TR]
[TR]
[TD="width: 21, bgcolor: transparent"]

8​

[/TD]
[TD="width: 64"]

22​

[/TD]
[TD="width: 64"]

23​

[/TD]
[TD="width: 64"]

31​

[/TD]
[TD="width: 64"]

76​

[/TD]
[TD="width: 64"]

29​

[/TD]
[/TR]
</tbody>[/TABLE]


Here is the formula I created for Jan thru March:


=SUMPRODUCT($V$7:X7,$V$8:X8)/SUM($V$8:X8)


= 69.51

 

[Manny74]

Row 7 percentages represent how our users are being rated based on the surveys we have mailed to customers.
A third party company collects our surveys and provides us with the number of surveys and scores for each user.
So I take those percentages then just manually enter them in each cell for each month (for each user)...
Does that help?


BTW, For Feb (row 3) I used =SUMPRODUCT($V$7:W7,$V$8:W8)/SUM($V$8:W8)
That equals 65.93

For March (row 3) I used =SUMPRODUCT($V$7:X7,$V$8:X8)/SUM($V$8:X8)
That equals 69.51

I'm not sure how to do a Sumproduct, for let's say from Jan thru April?

 

[jtakw]

With your Limited explanation of the calculations you need, and you Not providing expected results based on your manual calculations...

So again, based on the formula(s) you're using in Post # 1 and Post # 11 above, my suggested formula in Post # 4 follows that logic and is correct to that extend.