| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate weighted averages of grades?
I need to calculate the weighted average of a students four exams with each
exam being worth a different amount. Some of the exams are worth 20% and others worth 40%. What formula would I use to calculate these? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate weighted averages of grades?
I'd use SUMPRODUCT
=SUMPRODUCT( (Sheet1!B1:B10),(Sheet1!C1:C10)) HTH, Barb Reinhardt "jesyh2o" wrote: I need to calculate the weighted average of a students four exams with each exam being worth a different amount. Some of the exams are worth 20% and others worth 40%. What formula would I use to calculate these? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weighted Averages | Excel Worksheet Functions | |||
| Weighted Averages? | Excel Worksheet Functions | |||
| averages on grades, how to input formula when it has a percentage | Excel Worksheet Functions | |||
| How do I convert A-E grades to number averages? | Excel Discussion (Misc queries) | |||
| Calculating weighted averages | Excel Discussion (Misc queries) | |||
Linear Mode
