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.

There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

AVERAGEIF and AVERAGEIFS functions in Excel used to calculate the average in a range of cells. Learn how to use AVERAGEIF and AVERAGEIFS.

Formulas and functions, the nuts and bolts of Excel, both enable you to perform calculations, but they differ in how they're created, what they do, and how they work. In this article, we'll strip ...

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Avoid misleading results in Excel! Learn the pitfalls of the Percent Of function and how to replace it with precise calculation methods.

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

How to Graph a Function in Excel. A mathematical function is a formula that takes an input, x, applies a set of calculations to it, and produces an output called y. By calculating a function at a ...