Attempting to weight
 

I am using the below formula to get a weighted sco

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

Attempting to weight
 

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 MVP
http://people.stfx.ca/bliengme
remove caps from email

"japc90" wrote in message
...
I am using the below formula to get a weighted sco

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

Attempting to weight
 

On Jul 27, 8:16*pm, "Bernard Liengme"
wrote:
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

"japc90" wrote in message

...



I am using the below formula to get a weighted sco

=(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.- Hide quoted text -

- Show quoted text -

Thanks...worked beautifully!