» Calculating the Average for Numbers Meeting Specified Criteria
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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))}
Book Store:
Recommended Books:
No comments have been submitted.
