If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Formula to calulate the weighted average
I need some help on a spreadsheet I am working on. I am suppose to use
absolute cell references to calculate the overall total for four exams by using the four weights found in a different cell range. As follows: Exam 1 weight 20% cell C/8 Exam 2 weight 20% cell C/9 Exam 3 weight 20% cell C/10 Final Exam weight40% cell C/11 Cell B/17 Cell C/17 Cell D/17 Cell E/17 Cell F/17 Student I exam I 84.0 exam 2 80.0 exam 3 83.0 exam final exam 72.0 overall total It states in Cell F17 enter a formula to calculate the weigted average of the first student's four exams. Use the weights found in the range C8:C11, matching each weight with the corresponding exam score. Use absolute cell references for the four weights.... HELP!!! I have no clue what to do here 
Ads 
#2




Formula to calulate the weighted average
=C8*B17+C9*C17+C10*D17+C11*E17 "Jrf" wrote: > I need some help on a spreadsheet I am working on. I am suppose to use > absolute cell references to calculate the overall total for four exams by > using the four weights found in a different cell range. As follows: > > Exam 1 weight 20% cell C/8 > Exam 2 weight 20% cell C/9 > Exam 3 weight 20% cell C/10 > Final Exam weight40% cell C/11 > > Cell B/17 Cell C/17 Cell D/17 Cell E/17 > Cell F/17 > Student I exam I 84.0 exam 2 80.0 exam 3 83.0 exam final exam 72.0 overall > total > > It states in Cell F17 enter a formula to calculate the weigted average of > the first student's four exams. Use the weights found in the range C8:C11, > matching each weight with the corresponding exam score. Use absolute cell > references for the four weights.... > > HELP!!! I have no clue what to do here > 
#3




Formula to calulate the weighted average
I _think_ your instructor wants this formula in F17:
=$c$8*b17 + $c$9*c17 + $c$10*d17 + $c$11*d18 The $'s means that these cells won't change if you copy the formula to other cellslike in F18, F19, ..., F9999. Another formula that may get you into trouble: =SUMPRODUCT($C$8:$C$11,TRANSPOSE(B17:E17)) This is an array formula. Hit ctrlshiftenter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Jrf wrote: > > I need some help on a spreadsheet I am working on. I am suppose to use > absolute cell references to calculate the overall total for four exams by > using the four weights found in a different cell range. As follows: > > Exam 1 weight 20% cell C/8 > Exam 2 weight 20% cell C/9 > Exam 3 weight 20% cell C/10 > Final Exam weight40% cell C/11 > > Cell B/17 Cell C/17 Cell D/17 Cell E/17 > Cell F/17 > Student I exam I 84.0 exam 2 80.0 exam 3 83.0 exam final exam 72.0 overall > total > > It states in Cell F17 enter a formula to calculate the weigted average of > the first student's four exams. Use the weights found in the range C8:C11, > matching each weight with the corresponding exam score. Use absolute cell > references for the four weights.... > > HELP!!! I have no clue what to do here  Dave Peterson 
#4




Formula to calulate the weighted average
Thanks so much! That did it for me..How do you copy that format without it
changing the first position to the next such as: =C9*B17+C10*C17+C11*D17+C12*E17 this is what I get when I try to auto fill.. "dhstein" wrote: > > =C8*B17+C9*C17+C10*D17+C11*E17 > > "Jrf" wrote: > > > I need some help on a spreadsheet I am working on. I am suppose to use > > absolute cell references to calculate the overall total for four exams by > > using the four weights found in a different cell range. As follows: > > > > Exam 1 weight 20% cell C/8 > > Exam 2 weight 20% cell C/9 > > Exam 3 weight 20% cell C/10 > > Final Exam weight40% cell C/11 > > > > Cell B/17 Cell C/17 Cell D/17 Cell E/17 > > Cell F/17 > > Student I exam I 84.0 exam 2 80.0 exam 3 83.0 exam final exam 72.0 overall > > total > > > > It states in Cell F17 enter a formula to calculate the weigted average of > > the first student's four exams. Use the weights found in the range C8:C11, > > matching each weight with the corresponding exam score. Use absolute cell > > references for the four weights.... > > > > HELP!!! I have no clue what to do here > > 
#5




Formula to calulate the weighted average
Dave, just curious about your comment line:
> Another formula that may get you into trouble: > =SUMPRODUCT($C$8:$C$11,TRANSPOSE(B17:E17)) Since it works, why would it get the OP into trouble?  Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:68 xdemechanik  
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Formula for Weighted Average  MJ  Excel Discussion (Misc queries)  2  May 12th 08 04:08 AM 
Moving Weighted Average formula  Ori  Excel Discussion (Misc queries)  5  August 17th 06 11:03 PM 
calculating a weighted average using formula  bob green  Excel Worksheet Functions  1  August 1st 05 10:33 PM 
calculating a weighted average uisng formula  bob green  Excel Worksheet Functions  1  August 1st 05 06:31 AM 
What is the formula for weighted average?  Seth23hare  Excel Worksheet Functions  1  November 23rd 04 09:49 PM 