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

barry houdini

If you have the exam scores (or percentages achieved) in A2:A5 and th
corresponding weights in B2:B5, e.g. 40%, 20% etc then you can use thi
formula for a weighted average

=SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5)

If the percentages in B2:B5 always total to 100% then you can dispens
with the sum part and use just

=SUMPRODUCT(A2:A5,B2:B5)

If you have exam scores in A2:A5 then these should all be a score fro
the same maximum amount

regards, barr
 
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
countif text values to represent different numerical values 5
Using SUMPRODUCT to find weighted averages 0
Conditional sumif? 5
Letter grades average 3
How do I calculate a weighted average in a pivot table? 0
Weighted Averages 7
Weighted Average across worksheets 5

Top