This function, I believe, is overlooked by many. It’s there in the list under Autosum, but many people just ignore it and work far too hard creating multi-step formulas in their spreadsheets, or worse ...

=AVERAGE(INDIRECT . in cell E2, because we're telling Excel that we ultimately want to find an average, and we're also using the INDIRECT function to tell Excel where to look to calculate this ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

We show you how to calculate a weighted average in Excel using SUMPRODUCT and SUM functions, providing step-by-step instructions, practical examples, and common use cases.

As well as using SUM and AVERAGE in the GROUPBY function argument, you can use the PERENTOF function, which turns the data into percentages to show the proportion a subset makes up of a whole dataset.