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?

In `C1`

put:

```
=SUM(A1+B1)
```

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.:

```
=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!*

Thank you David…works perfectly and so simple!