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

xl vba tutorialsyntax in excel definitionexcel command buttonsfor loop vba examplecopy range vbaproject status dashboard excelprotect macro excelmacro excel for dummiesvba update sqlshortcut for insert row in exceladodb connection objectclose workbook vbahow do i insert rows in excelexcel macro delete blank rowsexcel vba addresshow to insert a macro buttonvba enumerationrange cell vbavbscript listboxvba write to excelhow to enter a macro in excelexcel goto vbadcl in sql serverdeclare variables vbamacro to find duplicates in excelexcel vba rows selectexcel form creation tutorialsort statement in sqlexcel vba form controlsdefinition of worksheet in excelhow to unlock the excel sheet forgot the passwordunmerge cells in excelexcel workbook examplesaccess sql vbahow to remove duplicate rows in exceluse of sumif in excelworksheet tabmicrosoft excel create chartstacked bar chart excel 2007vba string to doublehow to use iferror function in excel 2010adodb connection string oraclehow to record a macro in excel 2007excel consolidate columnsexcel vba automationexcel hide functiontext box controlado connection in vbexcel macro samplesvba excel advanced tutorialwhat is a hyperlink in excelexcel hide tabsdefined names in excelddl syntaxsql query operatorspivot table chart excelvba in wordbuild macro in excelexcel vb macrovba code for msgboxmeeting schedule template excelexcel macro unprotect sheetdelete blank rows excel 2010writing macros in excel tutorialvba sub procedurelist box controlnested if in excel 2010ddl and dml commandsvba stopwhat is excel ribbon