What is the use of AVERAGEIF function?
AVERAGEIF Function in Excel find the Average of all numbers in a range based on a given criteria
What is the syntax of AVERAGEIF function?
AVERAGEIF( range, criteria,
range: range of cells that you want to check the criteria
criteria: condition which you want to apply
[average_range]: range of cells to find average based on criteria, if it is missing it will consider the first rang as average_range
AVERAGEIF Function in Excel – Examples
Example 1: finding Average of the salaries more than 2500
Example 2: finding Average of all Salries of HR Department
Example 3: finding Average of all Salries of Year 2012
Example 4: finding Average of all Salries of Year 2012
Example 5: finding Average of all Salries of Admin Department
Please refer the below article for more Statistical Excel functions.
Statistical Excel Formulas
Please refer the below article for more Excel Functions.
Excel Formulas | Home