Remember Me?

#### Menu

#1
April 1st 09, 12:27 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 7
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

#2
April 1st 09, 12:47 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2008 Posts: 266
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
April 1st 09, 01:39 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 35,218
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
cells--like 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 ctrl-shift-enter 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
April 1st 09, 02:22 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 7
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
April 1st 09, 05:09 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,221
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 Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post MJ Excel Discussion (Misc queries) 2 May 12th 08 04:08 AM Ori Excel Discussion (Misc queries) 5 August 17th 06 11:03 PM bob green Excel Worksheet Functions 1 August 1st 05 10:33 PM bob green Excel Worksheet Functions 1 August 1st 05 06:31 AM Seth23hare Excel Worksheet Functions 1 November 23rd 04 08:49 PM

All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017