Ask Your Question

How to add each line for Column A and Column B and place the answer in Column C for each line?

asked 2018-07-18 00:29:24 +0100

DSM gravatar image

I want to add across each line for Column A + Column B; and have the answer in Column C(for each line). So A1+B1 = C1, for each row I have data. Is there a way to do this without having to type out the formula for each row?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-18 00:43:51 +0100

David gravatar image

updated 2018-07-18 00:44:27 +0100

In C1 put:


Then click-and-drag down Col C the "handle" in the lower right corner of the C1 cell.


The column will populate correctly, i.e.:

... etc.

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

edit flag offensive delete link more


Thank you perfectly and so simple!

DSM gravatar imageDSM ( 2018-07-18 01:05:02 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-18 00:29:24 +0100

Seen: 96 times

Last updated: Jul 18 '18