AVERAGEIF function

Category:Statistics

Name in English:AVERAGEIF

That makes?

Gets the average of the numbers that meet the specified criteria.

Syntax

AVERAGEIF (range, criterion, [average_range])

  • range (mandatory ): Values ​​to be evaluated.
  • criterion (mandatory ): Criterion that determines the values ​​to be considered.
  • average_range (optional ): Range with values ​​to average. If you omit me the Range is used.

Examples

AVERAGEIF (A1: A25, “> 60”) = Average of all values ​​that are greater than 60

Leave a Comment