AVERAGE

The AVERAGE function calculates the arithmetic mean of a set of numbers - the sum of the values divided by how many there are.

Syntax

=AVERAGE(number1, [number2], ...)

Example

=AVERAGE(B2:B50)
' Returns the average of all values in B2:B50

Text and blank cells within the range are ignored automatically, but cells containing zero are still included in the calculation.

AVERAGEIF - Conditional Average

=AVERAGEIF(B2:B100, "Noida", D2:D100)
' Averages column D only where column B equals "Noida"

AVERAGEIFS - Multiple Conditions

=AVERAGEIFS(D2:D100, B2:B100, "Noida", C2:C100, "Male")
To ignore zeros when calculating an average, combine AVERAGE with an IF condition, e.g. =AVERAGE(IF(B2:B50<>0, B2:B50)) entered as an array formula.

Ready to Master Data Science?

Join Uncodemy's Data Science Course and build real, job-ready skills with expert mentors.

Explore Course