AVERAGEIF Function in Excel: Syntax, Examples and Free Practice
AVERAGEIF is an Excel Math & Trig function. Averages numbers that meet one condition.
AVERAGEIF syntax
Arguments
range: The range of cells to checkcriteria: The range containing the conditions to applyaverage_range: The range to average, if different from the range being checked (optional)
When to use AVERAGEIF
AVERAGEIF is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice AVERAGEIF online, free
Open the live Excel-style spreadsheet and try AVERAGEIF yourself. No Excel install or sign-up needed to start.
Practice AVERAGEIF now →Watch: AVERAGEIF in Excel
Learn more
Read the tutorial: AVERAGEIF and AVERAGEIFS.
More Math & Trig functions
Frequently asked questions
What does the AVERAGEIF function do in Excel?
Averages numbers that meet one condition.
What is the syntax of AVERAGEIF in Excel?
The syntax is =AVERAGEIF(range, criteria, [average_range]). range: The range of cells to check; criteria: The range containing the conditions to apply; average_range: The range to average, if different from the range being checked (optional).
Where can I practice AVERAGEIF online for free?
Open the free live spreadsheet on Cellgrids and try AVERAGEIF yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts