Ignore Zeros

John Walkenbach, Excel 2002 Formulas, http://j-walk.com/ss/books/bookxl21.htm

Zeroes can make statistcal data inaccurate at times so here is a way to ignore them in your calculations.

=AVERAGE(IF(A1:A10<>0,A1:A10))



© Copyright andrewsexceltips.net All Rights Reserved.