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, say A3 + B3 and have the sum of those two cells in C3, but apply this principle to the whole columns, so I will also get sum of A4 + B4 in C4 etc. all the way down to the sum of A432 + B432 in C432.

I am sure it's quite simple if you know how.

share|improve this question

1 Answer 1

In cell C3 type the formula

=A3+B3

select C3. Right click » Copy. Select C432. To select the entire range C3–C432, press CtrlShift. Paste via CtrlV.

There are a dozen ways to do the same. As this is the most basic of tasks, perhaps a tutorial would be useful.

share|improve this answer
    
Works a treat!Thanks for your help. I guess a tutorial is the way to go for this user...... –  Robin Jan 31 '13 at 22:08

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.