To calculate the average, Excel sums all numeric values and divides by the count of numeric values.
AVERAGE takes multipleargumentsin the formnumber1,number2,number3, etc.
up to 255 total.
Arguments can include numbers, cell references, ranges, arrays, and constants.
Empty cells, and cells that contain text or logical values are ignored.
However, zero (0) values are included.
you might ignore zero (0) values with theAVERAGEIFS function, as explained below.
The AVERAGE function will ignore logical values and numbers entered as text.
If it’s crucial that you include these values in the average, see theAVERAGEA function.
If the values given to AVERAGE contain errors, AVERAGE returns an error.
you’re able to use theAGGREGATE function to ignore errors.
Blank cells
The AVERAGE function automatically ignores blank cells.
To exclude zero values, useAVERAGEIForAVERAGEIFSinstead.
In the example below, AVERAGEIF is used to exclude zero values.
Like the AVERAGE function, AVERAGEIFautomatically excludesempty cells.
Average without #DIV/0!
The average function automatically ignores empty cells in a set of data.
However, if the range contains no numeric values, AVERAGE will return a #DIV/0!
When the count is greater than zero, AVERAGE returns the average.This exampleexplains this idea in more detail.
For example, =MEDIAN(1,2,3,4,5) returns 3.
MODE Function
The Excel MODE function returns the most frequently occurring number in a numeric data set.
For example, =MODE(1,2,4,4,5,5,5,6) returns 5.
AVERAGEA Function
The Excel AVERAGEA function returns the average of a set of supplied values.
