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

Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally.

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.

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