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



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


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

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.


  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?



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

      Hi Robert,
      In Google Sheets is the same

Leave A Comment

Related pages

sort formula in excelsheet activate vbaexcel formula for difference between two datesexcel reporting tutorialhow to delete multiple entries in excelhow to write excel macromacro basics excelfilter in excel vbaexcel tab shortcutsumifs excel examplecountif function in excel 2007excel macro collectionwhat are ddl statementsvba insert blank rowwhat is the use of macro in excel 2007delete excel rowsvb interview questions and answersautofilter vba excelcustomer management excel templatehow to use pivot table in excel 2003examples of vlookup in excel 2010example of lookup in excelprotect columns in excel 2007how to make pivot chart in excel 2010vba status bar progressexcel tutorial beginnerexcel widget dashboardexcel macro wait timecreate macros in excelpractice pivot tablesstart vba in excelsas interview questions pdf free downloadvba codes for accessvba internetexplorer applicationexcel merge columnvba timevaluehow to lock and unlock cells in excelhow to protect workbook in excel 2007sql excel tablecopy worksheet excelexcel template for project trackingvb clear listboxawesome excel tricksexcel change columns to rowsexamples for vlookup in excelexcel vba msgbox vbyesnovba start programdelete rows in vbaexcel sumifnested if statement in excel 2010excel to csv converterspotfire basicsgoto label vbahow many columns and rows in excel 2010excel vba programming pdfswot word templateexcel vba is nothinghow to use two if statements in excelinsert text box excelexcel vba adodb connection string sql serverhow to find duplicate values in two columns in excelminimise shortcut keyconsolidate cells in exceldelete rows in excel vbavba code accesscool excel tablesdebug print vbaunhide column in excelvba filesvba copy and pastecapacity planning excel templateexcel chart samplesproject plan timeline excel templatecombobox tutorialwhat is a vba macrovba print statement