Back
How to Use the AVERAGEIF and AVERAGEIFS Functions in Excel
Mar 6, 2025
Quick Links
Excel's AVERAGEIF and AVERAGEIF functions let you find the average of a set of data. However, where they differ from the more straightforward AVERAGE function is in their ability to include or discount certain values within the calculation.
How to Use AVERAGEIF in Excel
Excel's AVERAGEIF function allows you to calculate the mean of a dataset that has been filtered based on a single condition you set.
The AVERAGEIF Syntax
The AVERAGEIF function has three arguments:
=AVERAGEIF(x,y,z)
where
x (required) is the range of cells to test against the criteria,
y (required) is the criterion (the test for argument x), and
z (optional) is the range of cells to average if the test in argument y is met. If you leave z out, Excel will average the values identified in argument x.
AVERAGEIF in Action
Let's jump straight in and see how the AVERAGEIF function works in a real-world example.
Let's suppose you have this Excel table containing 12 people's names, ages, and salaries, and you've been asked to calculate the average salaries of people aged over 40.
In this case, thinking back to the syntax above, column B contains the values you want to test (argument x), more than 40 is the criterion (argument y) for the values in column B, and column C contains the values you want to average (argument z).
14Shares
0Comments
4Favorites
15Likes
No content at this moment.