Blog · AVERAGEIFS

AVERAGEIFS with Multiple Criteria

How to use AVERAGEIFS with multiple conditions and criteria.

What is AVERAGEIFS?

Returns the average of a range depending on multiple criteria.

Syntax

AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Step-by-Step Guide

1. Understand the arguments — AVERAGEIFS requires specific inputs. Review the syntax above and make sure you understand each argument.
2. Set up your data — Organize your data with clear headers and consistent formatting before applying the formula.
3. Write the formula — Start typing =AVERAGEIFS( in any cell and Google Sheets will show you the argument hints.
4. Test with sample data — Verify the output matches your expectations before applying to your full dataset.
5. Handle errors — Wrap in IFERROR() to gracefully handle edge cases: =IFERROR(AVERAGEIFS(...), "N/A")

Expert Tips

Like SUMIFS, the average_range comes first.

Related Functions

Check out our complete formula reference for more Google Sheets functions.

Need Help?

Our Google Sheets experts build custom solutions every day. Get a free quote →