Ask Your Question
1

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 +0200

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
2

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

David gravatar image

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

In C1 put:

=SUM(A1+B1)

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

screenshot

The column will populate correctly, i.e.:

=SUM(A1+B1)
=SUM(A2+B2)
=SUM(A3+B3)
... 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

Comments

Thank you David...works perfectly and so simple!

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

Question Tools

1 follower

Stats

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

Seen: 32 times

Last updated: Jul 18 '18