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.