Functions
AVERAGEIF
Average cells where range matches criterion
Try it
When to use it
When should I use AVERAGEIF instead of AVERAGE?
Use AVERAGEIF when you want to average only the cells in a range that satisfy a given condition, such as averaging sales figures above a threshold.
Used in
Syntax
AVERAGEIF(range, criterion, [avg_range])Examples
=AVERAGEIF({5,10,15,25,30},"<10") // => 5