AVERAGEIF function

The AVERAGEIF function in Excel is a useful tool for finding the average of a range of numbers that meet a specific condition. It allows you to specify a criterion and calculate the average of only those numbers that satisfy that condition.


AVERAGEIF(range, criteria, [average_range])


rangeThe range of cells to be evaluated against the given criteria.
criteriaThe condition that determines which cells in the range are included in the average. You can use logical operators (e.g., “>, <, =”) or expressions (e.g., “>5”, “Red”).
[average_range](Optional) The range of cells containing the numbers to be averaged. If not provided, the function uses the “range” for averaging.

How to Use

Here’s how to use the AVERAGEIF function with examples:

Example 1: Find the average of test scores that are greater than 80 in the range A1:A10.

Example 2: Calculate the average of sales in the “West” region from the range A1:A20, where column B contains the region names.

Example 3: Compute the average of values in the range C1:C15, which corresponds to dates falling in the month of January.

Example 4: To find the average of all values that are not empty in the range D1:D30.

The AVERAGEIF function is a powerful tool to quickly calculate averages based on specific criteria, making it an essential part of Excel’s functionality for data analysis.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.