ExcelBanter - How do I calculate weighted averages of grades?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I calculate weighted averages of grades? (https://www.excelbanter.com/excel-discussion-misc-queries/245840-how-do-i-calculate-weighted-averages-grades.html)

jesyh2o

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?

Barb Reinhardt

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?

All times are GMT +1. The time now is 05:58 AM.