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 yet. Stay tuned!