Skip to content

Calculate Weighted Average in Excel

In this article, I will show you how to calculate a weighted average in Excel. Take the following setup, for example.

The Setup

The goal is to calculate the final score given the student’s score totals for each type of assignment. And each type of assignment carries a different weight toward the final score.

The Formula

With the scores and weights laid out next to each other, you can use the SUMPRODUCT function to calculate the weighted average.

=SUMPRODUCT(C3:C7, D3:D7)

The SUMPRODUCT function multiplies each value from the first range with each from the second range. The SUMPRODUCT function then adds up each multiplication result to give you the final calculation.

As a result, you end up with the weighted average.

In Summary

To summarize the steps required to calculate the weighted average:

  1. List the weights and scores next to each other.
  2. Use the SUMRPODUCT function to calculate the weighted average.

This Post Has One Comment

  1. I remember back in college, I would do all of that by row. This is so much faster! I love all your tips and tricks!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top