how copy formula that contains ranges so ranges do not overlap

[Patty]

I have a formula on one worksheet that finds the max value of 3 cells on
another worksheet. I want the formula below it to move to the next three
cells not overlap the rows. When I drag them it copies overlapping cells.
What I am looking for is example: =MAX(Spread!B118:B120) next row the formula
would be =MAX(Spread!B121:B123) how do you do that where you do not have to
enter each formula for each row?
thank you

 

[Mike H]

Patty,

Try this

This does B118 - B120 but dragged down 1 cell becomes B121 B123
=MAX(OFFSET(Spread!B$118,(ROWS($1:1)-1)*3,,3))

Mike