How to Use the AVERAGEIF and AVERAGEIFS Functions in Excel
Be selective about what to include in your average calculations.
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.
