Menu
EXCEL AVERAGEIF FUNCTION
Excel AVERAGEIF Function Introduction
This function computes the average of all cells in a range that fulfil the criterion.
Description of Excel AVERAGEIF Function
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.
Key Points
- 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 NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
