Excel Forum

Mr Excel & excelisfun Trick 13: AVERAGE without Zeroes

See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new Excel 2007 function. Also see Mr Excel use Fine and Replace to complete two amazing Average without Zeroes tricks.

Got a Question? Ask it Here in the Forum.