Q: Add number of column to a referenced range

  • Thread starter Thread starter John
  • Start date Start date
J

John

I need to copy this formula:
=A1+B1-SomeSheet!A1

I need the reference to SomeSheet!A1 to move over 11 columns to L11.
Is there a way to have the formula add this number of column so I
don't have to specify SomeSheet!L11?

TIA!
 
John

just drag the formula across; it should adjust as you go:

=A1+B1-Sheet8!A1 > =B1+C1-Sheet8!B1 > .... > =L1+M1-Sheet8!L1

Regards

Trevor
 
Back
Top