First of all, you can simplify your formula to this:

=IF(SUM(SheetOne!H112:J112)40,SUM(SheetOne!H112:J 112)-35,0)
=IF(SUM(SheetOne!H119:J119)40,SUM(SheetOne!H119:J 119)-35,0)

and so on.

It looks like you want to increase the reference rows by 7 on each
row, and you can do this using INDIRECT and the ROW() function. Which
row f the second sheet contains the first formula? (and is this
referring to row 112 of SheetOne?)

Hope this helps.

Pete

On Apr 23, 5:36*pm, Janelle wrote:
I am trying to copy a long "=IF" formula down a row by dragging it. *The
"=IF" formula is linked to another worksheet, and I am trying to increase the
attached cell row references (to the linked worksheet) by more than one. *I
can only figure out how to stop the incrementation all together, or have it
increase by one each row. *How can I do this?

ie.

=IF(SUM(SheetOne!H112+SheetOne!I112+SheetOne!J112 40,SUM(SheetOne!H112+Shee*tOne!I112+SheetOne!J112)-35,0)
=IF(SUM(SheetOne!H119+SheetOne!I119+SheetOne!J119 40,SUM(SheetOne!H119+Shee*tOne!I119+SheetOne!J119)-35,0)