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

msdasql connection stringexcel check duplicate formulaexcel chart objectcolor index excelexcel formulas examplemerge sheets excelhow to unprotect a workbook in excel 2010 without passworddynamic dashboard excelvlookup excel vbaarea charts in exceloptimisation excelcreating userforms in excelexcel reverse vlookupdo until loop vbaexcel vba graphexcel macro copy sheethow to create bar chart in excel 2007how to sort rows in excelremove macros from exceldynamic pivot table sql serverexcel macro paste valuesrange variable vbavba application.filedialogaccess vba sql updateexcel macro matchhow to unhide first column in excelhow to insert a check box in excelhow to delete a column in excelvba and macrosfunction in vba excelyes no message box vbavba ms access tutorialexcel function hlookupvba code to open excel file from folderuseful excel macroauto refresh pivot table excel 2007drop down list in excel 2007ms excel lookup functionddl dml dcl in sqlexcel tutorial charts and graphscreate userformsave vba excelexcel test for beginnersvba getopenfilenamepublic sub vbaexcel vba sub functionexcel macro operatorsexcel shortcut sheetexcel vba message boxdashboard charts in excelhow to insert row on excelexcel vba copy rangeexcel cells.findvba excel basicsrun vbasas beginnersvisual basic trim functionexcel database queryvba code to save workbookmacros in sqlms excel iserrorvba code to open excel filehow to do drop down in excel 2007excel lookupscalculator vb codeadodb.connection providersql interview questions for freshervba query databaselocking formulas in excel 2010word vba saveasexcel vba formula in cellexcel change columns to rowsvlookup in vba