Your formula is using relative references, if you copy and paste it should
change the ranges accordingly (the cell below will get B11, the cell on the
right C11, etc).

Is this what you were asking?
Miguel.

"sunrosejenn" wrote:

i've got a spreadsheet that has B10 through Y10 (all the way down through
B51-y51). i've got the following formula =SUM(BOONE:VERKAMP!B10). how do I
go about setting up the spreadsheet with this formula without having to do
each box seperately (b10, c10, d10, b11, c11, d11 and etc)?