One way (array-entered:CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF(MOD(COLUMN(rng),3)=MOD(COLUMN(INDEX(rn g,1)),3),
IF(rng<"", rng)))

where "rng" is the range of data in your row. This assumes you want the
1st, 4th, 7th... entry.

If you want the 2nd, 5th, 8th...entry, change INDEX(rng,1) to
INDEX(rng,2), etc.



In article ,
LostwithoutLost wrote:

Hi there, thanks for all your help in advance. I am looking for a formula
that will average every 3rd entry on a row of data. I would like to set it
up so that it ignores empty cells. chris