Average of selected cells, array required?

Originally Posted by FDibbins

when I said odd or even numbers, i meant row numbers

Ah right. I've adapted it as my data starts in A2 thus:

=IF(MOD(ROW(),2)<>0,AVERAGE(A2:A3),"")

this returns a blank cell :/

then when I copy it down the next entry is

=IF(MOD(ROW(),2)<>0,AVERAGE(A3:A4),"")

but I want it to be

=IF(MOD(ROW(),2)<>0,AVERAGE(A4:A5),"")

even when I manually enter the cells I want (which is what I want to avoid) every other cell is returning blank