Here are two thoughts (both are array formulas*)....

If your list of cells is not very extensive:
B1: =AVERAGE(IF(ISNUMBER(MATCH(ROW(A1:A16),{1,6,11,16} ,0))*(A1:A160),A1:A16))

OR..if you want row numbers that end in 1 or 6:
B1: =AVERAGE(IF((MOD(ROW(A1:A16),10)={1,6})*(A1:A160) ,A1:A16))

*Note: To commit array an formula, hold down [Ctrl] and [Shift] when you
press [Enter].

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Mike McLellan" wrote:

How do I average the number in a non-contiguous range (e.g. A1, A6, A11, A16
etc) that are above zero?