Attempting to weight

  • Thread starter Thread starter japc90
  • Start date Start date
J

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.
 
Perhaps = ((D2*C2)+(D3*C3)+(D4*C4)+(D5*C5))/J2
otherwise only the last term is being divided by J2

or
=SUMPRODUCT(D2:D5,C2;C5)/J2

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

or
=SUMPRODUCT(D2:D5,C2;C5)/J2

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








- Show quoted text -
Click to expand...

Thanks...worked beautifully!
 
Back
Top