Excel Formulas to Calculate the Weighted Average ~ Easy Guide!!
Tags: excelformula, excelformulas
Published: 2020-12-08 11:36:15

---
title: Excel Formulas to Calculate the Weighted Average ~ Easy Guide!!
published: true
date: 2020-12-08 09:20:45 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-the-weighted-average-easy-guide/
---

 **Weighted Average** : It is a calculation that takes into account the varying degrees of importance of the numbers in a data set. In calculating a weighted average, each number in the data set is multiplied by a predetermined weight before the final calculation.

This page will describe the simple **formulas used to calculate the weighted average of listed values in Excel Office 365**. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to calculate the weighted average](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/EXCEL_nc7jnMC1OE.png)](https://geekexcel.com/excel-formulas-to-calculate-the-weighted-average-easy-guide/excel_nc7jnmc1oe/#main)<figcaption id="caption-attachment-18986">Formulas to calculate the weighted average</figcaption>
## General Formula:

- To calculate the weighted average in Excel, use the below formula.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(weights,values)/[SUM](https://geekexcel.com/sum-function/)(weights)**

## Syntax Explanations:

- **SUMPRODUCT****  **– In Excel, this function will multiply the corresponding arrays or ranges and return the sum of the products. Read more on the [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).
- **SUM** – The [**SUM Function**](https://geekexcel.com/sum-function/) helps to add the values in the cells.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input value from your worksheet.

## Example:

- Let’s consider the below image, to calculate the weighted average.
- Here, we will give the input ranges in **Column C** , **Column D** , **Column E**.
- Then, give the criteria of the given input values and define a name as **weights**.
- After that, enter the given formula in the formula bar section,
- Finally, we will get the result in **Cell G3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-35.png)<figcaption id="caption-attachment-18985">Example</figcaption>

## Summary:

From this tutorial, you can get some clarification on the **formulas used to calculate the weighted average in Excel Office 365**. Hope you like this article. Feel free to share your worthwhile **feedback** in the below section. To know further updates keep in touch with our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas for Counting Occurrences in the entire workbook!!](https://geekexcel.com/excel-formulas-for-counting-occurrences-in-the-entire-workbook/)**
- **[Formulas to Calculate Days, Hours & Minutes Between Two Datetimes!!](https://geekexcel.com/formulas-to-calculate-days-hours-minutes-between-two-datetimes/)**
- **[Formulas for Counting the Dates from a given Year in Excel!!](https://geekexcel.com/formulas-for-counting-the-dates-from-a-given-year-in-excel/)**
- **[Excel Formulas to Calculate the Average of a Numbers that Ignores Zero!!](https://geekexcel.com/excel-formulas-to-calculate-the-average-of-a-numbers-that-ignores-zero/)**