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.