Thanks, but I'm still getting an error. Maybe I should clarify "ignoring
errors". The cells being averaged contain averages themselves. I'm trying to
get an overall average in 3 categories. Some of the cells have an error
because that particular employee did nothing in that particular category
during this time frame. I need the formula to ignore those cells with errors
in getting the overall average. Sorry if I wasn't clear on that.

"Duke Carey" wrote:

Three array formulas, meaning enter them with Ctrl-Shift-Enter

for the first one:
=AVERAGE(IF(MOD(ROW(Z4:Z1000)-4,6)=0,Z4:Z1000))

second one
=AVERAGE(IF(MOD(ROW(Z6:Z1000)-6,6)=0,Z4:Z1000))

last one
=AVERAGE(IF(MOD(ROW(Z8:Z1000)-8,6)=0,Z4:Z1000))

"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