| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to limit the Weight of any weight distribution | Excel Discussion (Misc queries) | |||
| how to limit the Weight of any weight distribution | Excel Worksheet Functions | |||
| I am attempting to create a summary sheet | Excel Discussion (Misc queries) | |||
| Weight loss line chart to monitor weight loss progress | Charts and Charting in Excel | |||
| Attempting Excel Template | New Users to Excel | |||
Linear Mode
