Average every four lines

[Macro-wave]

I have a column with numbers in it, and I would like to programatically average every four rows in the column.
What is the easiest way to do this?

Thanks in advance
Macro-wave

[Bob Phillips]

Try this array formula

=AVERAGE(IF(MOD(ROW(A2:A200),4)=0,A2:A200))