How do I sum using relative cell positions?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set up a formula that calculates a sum based on the data in the 12
columns to the left of the calculation cell. Something like:
SUM(RC[-12]:RC[-1]), *but* if I insert a column to the left, I don't want the
reference to be adjusted to SUM(RC[-13]:RC[-2]).
Probably a simple answer, but I'm stumped.
Thanks,
 
DavidB,

Try using the INDIRECT worksheet function to "freeze" the columns . . .
something like:

=SUM(INDIRECT("A1:L1"))
 

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

Sum Indirect Using R1C1 Style 17
Conditional Multiply and Sum 2
Sumproduct problem 2
Using INDIRECT & R1C1 Ref style 5
Relative Reference in Conditional Formattin 1
Changing Sum Range Based on Date Chosen from Drop Down List 1
conditonal formatting in VB 2
How can I use a UDF in a SUM Function? 2

Back
Top