### VBA Projects

###### Full Access with Source Code
• Designed and Developed by PNRao

• Full Access with VBA Source Code

• Well Commented Codes Lines

• Creative and Professional Design

#### 120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

###### 120+ PM Templates Includes:
• 50+ Excel Templates

• 50+ PowerPoint Templates

• 25+ Word Templates

Share Post

## 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,

[average_range] )

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

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

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.

Save Up to 85% LIMITED TIME OFFER

###### Project Portfolio Management Templates
Categories: Excel FormulasTags: Last Updated: June 17, 2022

1. Robert May 16, 2017 at 9:51 PM

Thank you for this tutorial.

Do you also have one on AVERAGEIF in Google Sheets?

Yours,

Robert

2. Jonatan June 22, 2017 at 3:12 AM

Hi Robert,
In Google Sheets is the same
Best,