# Google Sheets AVERAGE.WEIGHTED Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/averageweighted-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) Returns the weighted average of a set of values, given matching weights. ``` =AVERAGE.WEIGHTED(values, weights, [additional_values, additional_weights, ...]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the AVERAGE.WEIGHTED you need in plain EnglishGenerate Formula ## Parameters | Parameter | Required | Description | | - | - | - | | **values** | Yes | The values to average. Can be a range or array. | | **weights** | Yes | The weight for each value. Must be the same size as **values**. | | **additional\_values, additional\_weights, ...** | No | More pairs of values and weights to include in the same weighted average. | ## What Is AVERAGE.WEIGHTED? AVERAGE.WEIGHTED calculates a mean in which some values count more than others. Each value is multiplied by its weight, the products are added up, and the total is divided by the sum of the weights. This is the right calculation whenever items differ in importance or size, such as course grades with different credit values or prices across orders of different quantities. A plain [AVERAGE](https://betteranalyst.com/google-sheets/average-function) treats every value equally, which can give a misleading answer when, say, one order is for 1,000 units and another is for 2. ## How AVERAGE.WEIGHTED Works The calculation is: **weighted average = (value₁ × weight₁ + value₂ × weight₂ + …) ÷ (weight₁ + weight₂ + …)** The values and weights ranges must be the same size, and they are paired by position: the first value goes with the first weight, and so on. Weights do not need to add up to 1 or 100. Google Sheets divides by their total, so weights of 2, 3, and 5 behave exactly like 20%, 30%, and 50%. ## Basic Examples ### Weighted grade Scores in B2:B4 (85, 92, 78) and weights in C2:C4 (20%, 30%, 50%): ``` =AVERAGE.WEIGHTED(B2:B4, C2:C4) ``` Returns 83.6: (85×0.2 + 92×0.3 + 78×0.5) ÷ 1. ### Average price weighted by quantity ``` =AVERAGE.WEIGHTED(C2:C100, D2:D100) ``` With unit prices in C and quantities in D, this returns the true average price paid per unit across all orders. ### Typed values and weights ``` =AVERAGE.WEIGHTED({10, 20, 30}, {1, 1, 2}) ``` Returns 22.5, because the 30 counts twice. ### Combining two blocks of data ``` =AVERAGE.WEIGHTED(B2:B10, C2:C10, F2:F10, G2:G10) ``` Treats both value/weight pairs as one data set. ## The Equivalent SUMPRODUCT Formula Before AVERAGE.WEIGHTED existed, people wrote: ``` =SUMPRODUCT(B2:B4, C2:C4) / SUM(C2:C4) ``` Both formulas return the same answer. AVERAGE.WEIGHTED is shorter and states the intent more clearly. The SUMPRODUCT version is still useful when you need to add conditions inside the calculation. ## Common Use Cases - **Grading**: assignments, exams, and projects with different weights - **GPA**: grade points weighted by course credits - **Pricing**: average unit price weighted by units sold - **Finance**: average return of a portfolio weighted by position size - **Surveys**: responses weighted to match a population ## Common Errors - **Mismatched sizes**: If **values** and **weights** have different dimensions, the formula returns an error. Check that both ranges start and end on the same rows. - **Weights summing to zero**: The formula divides by the total weight, so zero total weight produces a division error. - **Negative weights**: Weights cannot be negative, though they can be zero, and at least one weight must be positive. - **Text in the ranges**: Make sure both ranges contain only numbers; clean imported data first. ## Tips and Best Practices - Store weights as percentages or as raw counts, whichever is easier. The result is the same because the function normalises by their total. - Show the total weight next to the result with [SUM](https://betteranalyst.com/google-sheets/sum-function) so readers can see what the average is based on. - Round the output with [ROUND](https://betteranalyst.com/google-sheets/round-function) for reports. - To weight only some rows, filter both ranges with the same FILTER condition, or use SUMPRODUCT with a condition. ## Related Functions - [AVERAGE](https://betteranalyst.com/google-sheets/average-function): equal-weight mean - [AVERAGEIF](https://betteranalyst.com/google-sheets/averageif-function): mean of values meeting a condition - [SUM](https://betteranalyst.com/google-sheets/sum-function): total of the weights - [ROUND](https://betteranalyst.com/google-sheets/round-function): format the final average ## Example use case A teacher grades homework at 20%, quizzes at 30%, and the final exam at 50%. Listing a student's three scores in B2:B4 and the weights in C2:C4, =AVERAGE.WEIGHTED(B2:B4, C2:C4) gives the correct final grade without a manual calculation. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Wrap Text In Google Sheets](https://betteranalyst.com/google-sheets/how-to-wrap-text-in-google-sheets) - [Google Sheets Conditional Formatting](https://betteranalyst.com/google-sheets/google-sheets-conditional-formatting) - [How To Add A Column In Google Sheets](https://betteranalyst.com/google-sheets/how-to-add-a-column-in-google-sheets) - [How To Alphabetize In Google Sheets](https://betteranalyst.com/google-sheets/how-to-alphabetize-in-google-sheets) - [How To Autofit In Google Sheets](https://betteranalyst.com/google-sheets/how-to-autofit-in-google-sheets) - [How To Calculate Percentage In Google Sheets](https://betteranalyst.com/google-sheets/how-to-calculate-percentage-in-google-sheets) - [How To Combine Two Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-combine-two-columns-in-google-sheets) - [How To Copy Formula In Google Sheets](https://betteranalyst.com/google-sheets/how-to-copy-formula-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.