Average formula while skipping rows

[arcadianwind]

I have data on a sheet labelled "Stats" that I would like to compute averages with to put on a sheet labelled "Summary Sheet". My data should go like this:

Summary Sheet G5 = average(Stats!I2:I4)
Summary Sheet G6 = average(Stats!I5:I7)
Summary Sheet G7 = average(Stats!I8:I10)
and so on.

How do I skip rows when dragging down this formula? I saw another thread discussing a similar problem but they were just trying to grab one piece of data from the original sheet, not several.

Thanks in advance.

 

[Joe4]

Welcome to the Board!

Try putting this formula in cell G5 and copy down:

=AVERAGE(OFFSET(Stats!I$2:I$4,(ROW()-5)*3,0))