How do I calculate weighted averages of grades?

  • Thread starter Thread starter jesyh2o
  • Start date Start date
J

jesyh2o

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?
 
I'd use SUMPRODUCT

=SUMPRODUCT( (Sheet1!B1:B10),(Sheet1!C1:C10))

HTH,
Barb Reinhardt
 
Back
Top