Excel AVERAGEIF Function

What is AVERAGEIF function in Excel?

The AVERAGEIF function is one of the Statistical functions of Excel.

It finds the average(arithmetic mean) for the cells specified by a given condition or criteria.

We can find this function in Statistical category of insert function Tab.

How to use AVERAGEIF function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select AVERAGEIF function.

6. Then select ok.

excel AVERAGEIF function

7. In the function arguments Tab you will see AVERAGEIF function.

8. Range section is the range of cells you want to be evaluated.

9. Criteria is the condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average.

10. Average range is the actual cells to be used to find the average. If omitted, the cells in the range are used.

11. You will see the results in the formula result section.

Examples of AVERAGEIF function in Excel

AVERAGEIF related functions 

  • Use AVERAGE function to return the average of its arguments, which can be numbers or names, arrays, or references.
  • Use AVERAGEIFS function to find average for the cells specified by a given set of conditions or criteria.
  • Use AVERAGEA function to return the average of its arguments, evaluating text and FALSE in arguments as 0; TRUE evaluates as 1.

Leave a Reply

Your email address will not be published. Required fields are marked *