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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with a formula 8
Problem with ISBLANK Function 5
...lookup? 3
Macro that copies values from column A (from formula) to B (paste value) 1
Concantenate which keeps bold of some parts. 5
Show other cell if blank 5
why won't text-to-columns work here? 6
lookup and return column number 2

Back
Top