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...

	V​	W​	X​	Y​	Z​
	Jan​	Feb​	Mar​	Q1​	Apr ​
7​	57.60%​	73.90%​	74.70%​	69.51%​	71.40%​
8​	22​	23​	31​	76​	29​

<tbody> </tbody>

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.