|  

» 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))}
Screenshot // Calculating the Average for Numbers Meeting Specified Criteria
Calculating the Average for Numbers Meeting Specified Criteria

Rate This Tip
12 34 5
Rating: 2.30     Views: 30043
No comments have been submitted.
Name
Comment Title
Comments