Thread: How do I calculate weighted averages of grades?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default 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 With QuoteReply With Quote