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
ON SALE80% OFF
50+ Project Management Templates Pack
Excel PowerPoint Word
Advanced Project Plan & Portfolio Template
Excel Template
Business Presentations Templates Pack
PowerPoint Slides
20+ Excel Project Management Pack
Excel Templates
20+ PowerPoint Project Management Pack
PowerPoint Templates
10+ MS Word Project Management Pack
Word Templates
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
Reference:
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
Thank you for this tutorial.
Do you also have one on AVERAGEIF in Google Sheets?
Yours,
Robert
Hi Robert,
In Google Sheets is the same
Best,