AVERAGEIFS Formula Generator
AVERAGEIFS calculates the average of cells that meet multiple criteria. Useful for performance analysis, salary reports, and statistical comparisons across categories.
Syntax
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)Try it — generate a AVERAGEIFS formula
Examples
Average salary by department
=AVERAGEIFS(C:C, B:B, "Engineering")Calculates the average of column C where column B is "Engineering".
Average score for passing students
=AVERAGEIFS(B:B, B:B, ">=60")Averages scores in column B that are 60 or above.
Tips
- ✓AVERAGEIFS ignores cells with text or blanks in the average range automatically.
- ✓Combine with date criteria for period-specific averages.
Related Formulas
SUMIFS
SUMIFS adds up values that meet multiple criteria. It's essential for financial ...
COUNTIFS
COUNTIFS counts cells that meet multiple criteria across different columns. Perf...
SUMPRODUCT
SUMPRODUCT multiplies corresponding elements in arrays and returns the sum. It's...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free