Formulas > =AVERAGEIF()
How To Use AVERAGEIF() Function in Google Sheets
Description
How To Actually Use AVERAGEIF() in Sheets
AVERAGEIF(criteria_range, criterion, [average_range])
Try AVERAGEIF yourself
Use the AVERAGEIF formula to calculate the average of values in B1:B10 where the corresponding values in A1:A10 are greater than 10.
Hints (2)
-
Remember to specify the criteria for filtering the values.
-
Make sure to reference the correct ranges for both criteria and average.
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 AVERAGEIF() formula:
Generate a AVERAGEIF() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses AVERAGEIF(). 2 free AI generations, no signup. Members get unlimited use.
Generate a AVERAGEIF() formula