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