Tip Printed from ExcelTip.com

---

Calculating the Average for Numbers Meeting Specified Criteria


Problem:

We want to calculate the average of all prices in column A that are higher than 200.

Solution:

Use the IF and AVERAGE functions in the following Array formula:
{=AVERAGE(IF(A2:A7>B2,A2:A7))}