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 2 columns of data and output the sum into a third column, with a =sum(a1+b1). With many rows of data, I try dragging down the highlighted cell to Fill the rest of the output column with the sum function. However, the top number is propagated to the rest of the rows, even though the function in the cell appears to be correct (for example =sum(a3+b3)). Is this a bug? My data is not text, no leading spaces, etc. Thanks.

share|improve this question

1 Answer 1

No, it is not a bug.

If you get the result you expected from keyeing F9 you might want to go to Tools, Calculate and check AutoCalculate.

As an aside =a1+b1 should be sufficient instead of =sum(a1+b1).

share|improve this answer
1  
Yes, thank you! The toggle was actually located in Tools -> Cell Contents. This should be on by default! :) –  user189977 Jan 15 '13 at 20:07

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.