I think you might want to use the OFFSET function for this. Without knowing
what cell references you're using, I'll just assume your data starts in A1 on
both sheets.

On Sheet2 enter:

=OFFSET(Sheet1!$A$1,0,ROW()-1)+OFFSET(Sheet1!$A$2,0,ROW()-1)

By using the ROW function in the column reference of the OFFSET function,
you should get your desired incrementation results when the formula is copied
down Sheet2.

HTH,
Elkar


"STAR263" wrote:

I want to add two cells on worksheet 1 to sum in a cell on worksheet 2 in the
same workbook. Then I want to copy that formula down a few cells on whsht 2
letting the columns change and the row remain static. However, when I copy
down the formula it changes the rows and keeps the column. If I anchor the
row, it copies the exact formula changing nothing. I need an answer in a
hurry!