fbpx
Search
Close this search box.

Weighted Average in Excel [Formulas]

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

Continue »

How to get non-adjacent columns with FILTER function in Excel

How to get non-adjacent columns with FILTER function in Excel

Excel 365’s FILTER() function is great for getting a cut of data that meets your criteria. But what if you need to filter and then show non-adjacent columns? Something like below. In this article, let me show you a few options to get discrete columns after filtering with the FILTER function.

Continue »

What is XLOOKUP and how to use it in Excel?

What is XLOOKUP and how to use it in Excel?

Think of XLOOKUP as an improved version of VLOOKUP. In this article, learn all about the XLOOKUP function, it’s syntax, parameters with real-world xlookup examples.

Continue »

Extract BOLD portion of a cell in Excel using getBoldText() function

Extract BOLD portion of a cell in Excel using getBoldText() function

Use the getBoldText() function in Excel to extract bolded portion of a cell automatically. Saves you time and helps with data cleaning.

Continue »

How to fix SPILL Error in Excel Tables (3 easy solutions)

How to fix SPILL Error in Excel Tables (3 easy solutions)

So you have a SPILL error in your Excel tables? In this quick article, let me show you 3 easy fixes to the problem. Fix 0: See if Excel can auto-fix the formula This is not really a fix. But if you write certain types of formulas in table, Excel will warn you about the […]

Continue »

Loan Amortization Schedule in Excel – FREE Template

Loan Amortization Schedule in Excel – FREE Template

Do you want to calculate loan amortization schedule in Excel? We can use PMT & SEQUENCE functions to quickly and efficiently generate the full loan amortization table for any number of years.

Continue »

How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]

How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]

Do you want to create a dynamic dependent drop down list in Excel like below? You can use XLOOKUP and data validation to set this up quickly. It is fully dynamic and works across a full column too.

Continue »