Statistics definition of Average for Valid Numbers

Average

Average = (sum of all valid values)/(count of valid values)

The average value of any array is the sum of all valid numbers divided by the count of valid numbers.

In Business Statistics.xls you can set upper level and lower level boundaries and discard zeros. The resulting data series consists of valid values only.