autofill cell references

[imported_unknown]

Hi all,
I'm trying to calculate the average of every three rows. I would write down the function =Average(A1:A3) in cell B1. When I do an autofill in B2, the formula would read =Average(A2:A4). What I actually want it to be is =Average(A4:A6). Any suggestions?

Thanks in advance.

 

[ThePencilQueen]

Select B1:B3 then autofill...it will give you the average for each group of three rows next to the top entry.

 

[imported_unknown]

Thank you very much pencilqueen. That technique works very well.

Leo