AVERAGEIF Excel Function - What Is It, Formula, Error, Examples.

What Is AVERAGEIF Function In Excel?

The AVERAGEIF function in Excel determines the average/mean of the selected cells in a dataset that satisfies the required criteria. The function is used to evaluate the central tendency, a measure representing the center of a set of data values in a statistical distribution.

The AVERAGEIF Excel function is an inbuilt Statistical function, so we can insert the formula from the “Function Library” or enter it directly in the worksheet.

📥Download the ready-to-use Excel template to practice this tutorial yourself.

Download Excel Template

For example, the first table below contains a list of fruits and their quantity, and the second table shows the criterion to determine the quantity values provided in the first table to get the average.

Frequently Asked Questions (FAQs)

1. Is there an AVERAGEIF function in Excel?

There is an AVERAGEIF function in Excel. It is in the Formulas tab, and we can select Formulas → More Functions → Statistical → AVERAGEIF to apply it in the required cell.

2. How to use AVERAGEIF() with the date criterion in Excel?

We can use AVERAGEIF() with the date criterion in Excel if we need the average units dispatched after 4/1/2022.

For example, the following table contains a list of items and their dispatch details.

The procedure to apply the Excel AVERAGEIF function with the required date criterion is:

Select cell G6, enter the formula =AVERAGEIF(B2:B11,G3,C2:C11), and press Enter.

The above formula checks for dates after 4/1/2022 in column B and then determines the average of the corresponding units, 2000, 900, 1170, 2300, and 2710, 1816 units.

3. How to use the AVERAGEIF() in Excel with a logical operator in criteria?

We can use the AVERAGEIF() in Excel with a logical operator in the criteria and determine the average contribution by volunteers aged 25 and above.

For example, the below table contains the details of the contributions made by a set of volunteers.

The procedure to apply the AVERAGEIF Excel function by volunteers aged 25 and above is,

Select cell G6, enter the formula =AVERAGEIF(B2:B11,”>=”&G3,C2:C11), and press Enter.
[Note: However, we may also enter the formula as =AVERAGEIF(B2:B11,”>=25″,C2:C11)]

The output is shown above.
[Output Observation: In this case, we must provide the required logical operator and the number in double quotations when supplying them as the criteria argument.
In the above formulas, the function checks for cells containing ages 25 and above in column B. And then, it averages the corresponding contribution values in column C (200, 120, 250, 300, and 350) to return the value of $244.]

Download Template