How do I calculate weighted averages of grades?

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?
 
B

Barb Reinhardt

I'd use SUMPRODUCT

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

HTH,
Barb Reinhardt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to calulate the weighted average 4
Conditional sumif? 5
Letter grades average 3
CALCULATE WITH AVERAGE ???? 1
SUMPRODUCT w/ Autofilter 2
Finding matching fields accross multiple worksheets 2
Weighted Averages 7
Calculating weighted averages 6

Top