3

I have a small issue with Excel. I doing transformations for some columns in the dataset. I know the number of the columns I want, but I wasn't able to use them in a formula. For example I want to add the 5th and the 10th column. How do I write this formula?

Note: I have tried the R1C1 reference style but it is not what I am looking for.

11
  • You may have to write a custom function that works out column 1 = A, column 2 = B, column 27 = AA, column 28 = AB etc. Your function should take a number and return a letter(s)
    – Kinnectus
    May 22, 2014 at 11:53
  • wow that's sad! I am not an excel user! I think I will do this in some other software then! thank you very much :)
    – Error404
    May 22, 2014 at 11:54
  • Excel functions aren't too difficult to learn!
    – Kinnectus
    May 22, 2014 at 12:05
  • True, I am planning to learn them, but it is a matter of time for me now. Much appreciated :)
    – Error404
    May 22, 2014 at 12:07
  • What Excel version? I have an answer for 2010 (just tested and works a treat)
    – Kinnectus
    May 22, 2014 at 12:07

1 Answer 1

4

You can do this with:

=SUM(OFFSET($A:$A,0,5-1),OFFSET($A$:$A,0,10-1))

Substitute 5 & 10 with calculations or cell references containing column numbers if needed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.