The AVERAGEIF Function of Excel calculates the average of the numbers in a range that meet the supplied conditions. The measures for AVERAGEIF Function supports logical operators and wildcards for partial matching.

- What is an AVERAGEIF Function in Excel?
- What is the formula for AVERAGEIF Function?
- What is the example of AVERAGEIF Function?
- How is AVERAGEIF Function different from AVERAGE Function?

**➡ What is an AVERAGEIF Function in Excel**

The AVERAGEIF Function of Microsoft Excel returns the average (arithmetic mean) of all numbers in a range of cells, based on a specified condition. It can be used as a worksheet function in Microsoft Excel. It can be entered in the form of a formula in a cell of a worksheet.

To find out which cells are averaged, criteria is applied to range. Criteria can be provided as numbers, strings, or references.

**➡ What Is The Formula For Averageif Function?**

The syntax used for AVERAGEIF Function is

**=AVERAGEIF (range, criteria, [average_range])**

Where,

**Range** – It can be one or more cells, including numbers or names, arrays, or references

**Criteria** – It is a number, expression, cell reference, or text

**Average Range** – It is known as cells to average. Range is used, when omitted

Recommended Blog:

**➡ What Is The Example Of Averageif Function?**

**AVERAGEIF** Function carry out an average, based on criteria you supply as discussed above. Now, let’s take an example to get a better idea.

**Example:**

As shown in picture below, we have a data table which consists of products and their prices. If we want to calculate the average price of all the products, then we can simply go for the** AVERAGE** formula. But if we want to calculate the average of selective prices of products, we have to use the **AVERAGEIF** formula.

In this scenario, we have calculated the Average price for the products that have the price greater than 10$using the AVERAGEIF formula –

**AVERAGEIF(I5:I8,”>10″)**

Also, we can calculate the average of price by applying the condition on the quantity using the AVERAGEIF formula –

**AVERAGEIF(H5:H8,”<10″,I5:I8)**

**➡ How Is Averageif Function Different From Average Function?**

The **AVERAGE Function** calculates the mean of cells with numbers while the **AVERAGEIF Function** calculates the average cells based on a given criteria.

**AVERAGE Function Syntax-** AVERAGE(number1, [number2], …)

**AVERAGEIF Function Syntax- **AVERAGEIF(range, criteria, [average_range])

**➡ Limitations-**

- The limitation of the
**AVERAGEIF function**is that you can only use one criterion at a time - The limitation of the
**AVERAGE Function**is that it simply averages a range of cells

**➡ Points To Remember**

- The AVERAGEIF Function ignores the cells in range that contain
**TRUE or FALSE** - It also ignores the
**Empty**cells in range while calculating averages - AVERAGEIF Function returns
**#DIV/0! error**if no cells in range meet the criteria - In AVERAGEIF Function the
**Average_range**does not have to be of the same size as range