"Dave Thomas" wrote...
Are you assuming there are no negative numbers? Treesy doesn't state that
there aren't. Treesy just wanted to eliminate 0's and blanks.
....

Name a physical, financial or not entirely esoteric process that could
produce positive and negative values but not zero values. The point is that
if a set of numbers can include positive and negative values, they very
likely could also contain legitimate zero values that shouldn't be ignored.

As for blanks, they're always ignored unless you mean "" and are (mis)using
AVERAGEA instead of AVERAGE or are averaging values through an external
reference to a closed workbook.