Shirley,

consider an array formula like

=AVERAGE(IF(A1:A1000, A1:A100))

confirmed with Shift+Ctrl+Enter. It averages over a virtual array of
either the nonzero numbers or FALSE in their place, which does not
count for average.

HTH
Kostis Vezerides