Returns the average of a range depending on multiple criteria.
81% OFF online library of tutorials for mastering Google Sheets
AVERAGEIFS()
Description
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.