Formulas > =AVERAGEIFS()
How to Use AVERAGEIFS() in Google Sheets
Description
How To Actually Use AVERAGEIFS() in Sheets
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Try AVERAGEIFS yourself
Use the AVERAGEIFS formula to calculate the average of the values in the range B2:B10, where the corresponding values in A2:A10 are greater than 10. The result should be displayed in cell D1.
Hints (2)
-
Remember to specify the average range first.
-
You'll need to use a comparison operator in your criteria.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the AVERAGEIFS() formula:
Generate a AVERAGEIFS() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses AVERAGEIFS(). 2 free AI generations, no signup. Members get unlimited use.
Generate a AVERAGEIFS() formula