Thanks for the feedback, Tammie....I'm glad that worked for you.

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

XL2002, WinXP


"tamiluchi" wrote:

Fabulous!! That worked perfectly. Thank you so very much.
Tammie

"Ron Coderre" wrote:

Try these ARRAY FORMULAS*:

For data in Z4:Z30

Every 6th item beginning with Z4
=AVERAGE(IF(ISNUMBER($Z$4:$Z$30)*(MOD(ROW($Z$4:$Z$ 30)-4,6)=0),$Z$4:$Z$30))

Every 6th item beginning with Z6
=AVERAGE(IF(ISNUMBER($Z$6:$Z$30)*(MOD(ROW($Z$6:$Z$ 30)-6,6)=0),$Z$6:$Z$30))

Every 6th item beginning with Z8
=AVERAGE(IF(ISNUMBER($Z$8:$Z$30)*(MOD(ROW($Z$8:$Z$ 30)-8,6)=0),$Z$8:$Z$30))

*Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter]

Is that something you can work with?
Does that help?
***********
Regards,
Ron

XL2002, WinXP


"tamiluchi" wrote:

Hi. I need to get the average of every 6th cell in a column, excluding errors
--- three times.
The first average should be every 6th cell beginning with z4, the second
every 6th cell beginning with z6, and the third every 6th cell beginning with
z8.
Is there an easy way to achieve these 3 averages?

Tammie