How to Use AVERAGEIF() in Google Sheets

Description

Returns the average of a range depending on criteria.

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.

Your formula

Hints (2)

Locale Separator ,

Official Docs

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

Transcript-matched member videos for AVERAGEIF(). Click through to watch.

Browse more tutorials

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sh...

Data validation Beginner

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bet...

Unlock these tutorials

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