AVERAGEIF Function in Excel

Home/Excel Formulas/AVERAGEIF Function in Excel

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

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Business Presentations Templates Pack
PowerPoint Slides

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


What is the syntax of AVERAGEIF function?

AVERAGEIF Function in Excel - Syntax

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

AVERAGEIF Function in Excel - Example 1
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

LIMITED TIME OFFER
By |March 1st, 2013|Excel Formulas|2 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

2 Comments

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

    Thank you for this tutorial.

    Do you also have one on AVERAGEIF in Google Sheets?

    Yours,

    Robert

    • Jonatan June 22, 2017 at 3:12 AM - Reply

      Hi Robert,
      In Google Sheets is the same
      Best,

Leave A Comment