top of page


The AVERAGEIF function allows us to compute the average of a range based on specific criteria.

The AVERAGEIF function follows the following syntax: =AVERAGEIF(range, criteria, [average_range])

  1. "range" refers to the range where our criteria will be evaluated.

  2. "criteria" represents the condition we want to check.

  3. [average_range] is an optional argument that indicates the range for which we want to calculate the average, considering only the cells that meet our criteria.

It's worth noting that [average_range] can be omitted in cases where the range argument is the same as the average_range argument.

bottom of page