Attempting to weight

[japc90]

I am using the below formula to get a weighted score:

=(D2*C2)+(D3*C3)+(D4*C4)+(D5*C5)/J2

The scores in my spreadsheet are in column D and are percentages.
These scores range from 0% - 100%. I need to weight these against the
numbers in column C which represent the number received. I than
divided by J2 which contains the sum of the numbers in column C.

The issue is the formula is returning weighted scores like 2515.11%.

I am totally lost on this one. Any assistance is appreciated.

 

[Bernard Liengme]

Perhaps = ((D2*C2)+(D3*C3)+(D4*C4)+(D5*C5))/J2
otherwise only the last term is being divided by J2

or
=SUMPRODUCT(D25,C2;C5)/J2

best wishes

 

[japc90]

Perhaps  = ((D2*C2)+(D3*C3)+(D4*C4)+(D5*C5))/J2
otherwise only the last term is being divided by J2

or
=SUMPRODUCT(D25,C2;C5)/J2

best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email








- Show quoted text -

Thanks...worked beautifully!