AVERAGEIFS Function in Excel: Syntax, Examples and Free Practice
AVERAGEIFS is an Excel Math & Trig function. Averages numbers that meet multiple conditions.
AVERAGEIFS syntax
Arguments
average_range: The range to average, if different from the range being checkedcriteria_range1: The first range to check against a conditioncriteria1: The first condition to match
When to use AVERAGEIFS
AVERAGEIFS is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice AVERAGEIFS online, free
Open the live Excel-style spreadsheet and try AVERAGEIFS yourself. No Excel install or sign-up needed to start.
Practice AVERAGEIFS now →Watch: AVERAGEIFS in Excel
Learn more
Read the tutorial: AVERAGEIF and AVERAGEIFS.
More Math & Trig functions
Frequently asked questions
What does the AVERAGEIFS function do in Excel?
Averages numbers that meet multiple conditions.
What is the syntax of AVERAGEIFS in Excel?
The syntax is =AVERAGEIFS(average_range, criteria_range1, criteria1, ...). average_range: The range to average, if different from the range being checked; criteria_range1: The first range to check against a condition; criteria1: The first condition to match.
Where can I practice AVERAGEIFS online for free?
Open the free live spreadsheet on Cellgrids and try AVERAGEIFS 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