average every 6th cell in a column
Z4 on:
=AVERAGE(IF((MOD(ROW($Z$4:$Z$1000),6)=4)*($Z$4:$Z$ 1000<""),$Z$4:$Z$1000))
Z6 on:
=AVERAGE(IF((MOD(ROW($Z$4:$Z$1000),6)=0)*($Z$4:$Z$ 1000<""),$Z$4:$Z$1000))
Z8 on:
=AVERAGE(IF((MOD(ROW($Z$4:$Z$1000),6)=2)*($Z$4:$Z$ 1000<""),$Z$4:$Z$1000))
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"tamiluchi" wrote in message
...
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
|