Relative references in a cell formula

[MarinM]

Hi, is it possible to write a formula in a one cell that is referencing cells relatively. E.g. I want to write a formula AVERAGE(A5;A11;A16;A21). Is it possible to write it like AVERAGE(A5;something with an increment+4 etc.)? Any help is appreciated
Best regards,

Marin

 

[xld]

Take a look at OFFSET in help, it sounds as though it will do what you want.