Consider the fact that if we include data points with 0 while getting the average.This would give incorrect result. As count would also increase resulting low average. Example take out the average of 0 and 20 this would give 10. Actually it should be 20.

The best way to use average formula is passing the criteria "<>0" i.e where data is not equal to zero.

=AVERAGEIF(A1:A5,"<>0")

The best way to use average formula is passing the criteria "<>0" i.e where data is not equal to zero.

=AVERAGEIF(A1:A5,"<>0")

## No comments:

## Post a Comment