Average numbers ignore zero

An excel formula to average numbers ignore zero

Related Functions

Sponsored Link

 Average numbers ignore zero
=AVERAGEIF(range,"<>0")

To get the average of a set of numbers, excluding or ignoring zero values, use the AVERAGEIF function.

In the example shown, the formula in E6 is:

 
=AVERAGEIF(B6:D6,"<>0")

How this formula works

AVERAGEIF performs an average based on criteria you supply. In this example, the criteria supplied is "<>0", which means "not equal to zero".

Like AVERAGE , AVERAGEIF automatically ignores blank cells and text.

Sponsored Link

0 votes. 0 / 5