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
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
Save Up to 85% LIMITED TIME OFFER
A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
Share This Story, Choose Your Platform!
2 Comments
Leave A Comment
You must be logged in to post a comment.
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,