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.