Need major help adding values to a Cell

[Longshotx]

Okay I'm not talking about adding cells C5 (6) to A5 (6) to equal 12.

I am doing some data analysis and I want to sequentially add a value (say 5) from the cell number so it would be like A5, A10, A15.

I have some formulas like this =average(E104,E135,M101) and the pattern I see is I need to be adding 8 to the cell (ex: E104 would be E112) so for the next one it would be =average(E112,E147,M109) and the one after that would be =average(E120,E155,M117). I hope I am making sense but how can I get this so I don't have to manually enter it in?

Please help!!! Thanks!

 

[jim may]

Are you looking for a Spreadsheet formula Solution or a VBA solution?

 

[Longshotx]

I am assuming spreadsheet. I can upload it if need be.

 

[shawnhet]

Oops, I misread the request. I would think that this has to be done with VBA though.

Cheers,