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!