How to Use AVERAGEIF Function

In Excel, you can use AVERAGE or AVERAGEA function to calculate the average of a whole group of numbers, or use AVERAGEIF function when you need to calculate the average of a group of numbers that meet one criterion.

Formula:

= AVERAGEIF(range, criteria, [average range])

Explanations:

– The range is required, which is the range of numbers to average;

– The criteria are required, which is the criteria you need to meet for average. You can use the wildcard characters such as the question mark (?) or the asterisk (*);

– [Average range] is optional; this is the actual range of cells to average. The range is used as the average range when it is omitted.

Cautions:

The AVERAGEIF function will count cells that contain only numbers. When there are multiple criteria, please use AVERAGEIFS function.

Example: What is the average in column C for those less than $70,000?

= AVERAGEIF(C2:C9,"<70000") The average is $57,593 for those less than $70,000.

Averageif function

Leave a Reply