81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

AVERAGEIFS()

Description

Returns the average of a range depending on multiple criteria.

How To Use in Sheets

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

External Links

Google Sheets - Average, Weighted Average, Average Ifs & Conditional Weighted Average

Learn how to calculate averages in Google Sheets. We'll cover AVERAGE, AVERAGEIFS, Weighted Average & Conditional Weighted Average.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.