EXCEL AVERAGEIF FUNCTION

This function computes the average of all cells in a range that fulfil the criterion.

Syntax:

=AVERAGEIF(range, criteria, [average_range])

Parameter list:

  • range – one or more cells to average, containing numbers or names, arrays, or references with numbers.
  • Criteria – a number, expression, cell reference, or language that specifies which cells are averaged.
  • [Optional] average range the actual collection of cells to average If range is not specified, the default value is used.

Step By Step Guide of AVERAGEIF Function

Example Here :

here to get Average of total marks, =AVERGEIF(C6:C10, “>20”) , returns 77.4, in which in the AVERAGEIF we are given range and criteria.

  • Cells in the range containing TRUE or FALSE are disregarded.
  • If a cell in average range is empty, AVERAGEIF disregards it.
  • AVERAGEIF returns the #DIV0! error value if range is an empty or text value.
  • If a cell in the criterion is empty, AVERAGEIF considers it to be a 0 value.
  • AVERAGEIF returns the #DIV/0! error value if no cells in the range match the requirements.
  • You can use wildcard characters such as the question mark (?) (which matches any single character) and the asterisk (*) (which matches any sequence of characters). Type a tilde () before the letter to find a real question mark or asterisk.
  • The size and shape of average range do not have to be the same as those of range. The actual cells averaged are chosen by starting with the top, left cell in average range and then includes cells that correlate in size and shape to range.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now