Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to add three columns and I want to to put that result in another column. How can I do this?

For example:

C   C1   C2   C3 
10   3    3    1

Here I want to add C1, C2 and C3 and store the result in column C.

share|improve this question
    
You can't. Every cell has a 2-dimensional reference. The answer to your sum will need to go into a cell on it's own, e.g. C4 –  Lee Taylor Nov 28 '12 at 11:54
    
Are you expecting 3+3+1 to equal 10? –  pnuts Dec 3 '12 at 20:13
add comment

2 Answers

keep data in A1,B1 & C1 & put =SUM(A1+B1+C1) in D1.

If you want to add up strings from three different columns, use merge.

For strings, you can use =Concatenate(A1,B1,C1)

share|improve this answer
    
Excel "under the hood" only stores s couple of datatypes: doubles & strings. In this case it would use doubles, not strings. –  Jeremy Thompson Nov 28 '12 at 11:07
add comment

I am answering this for the fun of it.

C   C1   C2   C3 
10   3    3    1

Click cell C4, then in the FormulaBar > type =SUM() > Highlight cells C 1-3 and press Enter

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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