Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 18 Jul 2018 01:05:02 +0200How to add each line for Column A and Column B and place the answer in Column C for each line?https://ask.libreoffice.org/en/question/160953/how-to-add-each-line-for-column-a-and-column-b-and-place-the-answer-in-column-c-for-each-line/ 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?Wed, 18 Jul 2018 00:29:24 +0200https://ask.libreoffice.org/en/question/160953/how-to-add-each-line-for-column-a-and-column-b-and-place-the-answer-in-column-c-for-each-line/Answer by David for <p>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?</p>
https://ask.libreoffice.org/en/question/160953/how-to-add-each-line-for-column-a-and-column-b-and-place-the-answer-in-column-c-for-each-line/?answer=160955#post-id-160955In `C1` put:
=SUM(A1+B1)
Then **click-and-drag** down Col C the "handle" in the lower right corner of the `C1` cell.
[![screenshot][1m]][1]
The column will populate correctly, i.e.:
=SUM(A1+B1)
=SUM(A2+B2)
=SUM(A3+B3)
... etc.
[1m]: https://i.imgur.com/a8Z9teMm.png "Click for larger resolution screenshot"
[1]: https://i.imgur.com/a8Z9teM.png
---
*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!*Wed, 18 Jul 2018 00:43:51 +0200https://ask.libreoffice.org/en/question/160953/how-to-add-each-line-for-column-a-and-column-b-and-place-the-answer-in-column-c-for-each-line/?answer=160955#post-id-160955Comment by DSM for <p>In <code>C1</code> put:</p>
<pre><code>=SUM(A1+B1)
</code></pre>
<p>Then <strong>click-and-drag</strong> down Col C the "handle" in the lower right corner of the <code>C1</code> cell.</p>
<p><a href="https://i.imgur.com/a8Z9teM.png"><img alt="screenshot" src="https://i.imgur.com/a8Z9teMm.png" title="Click for larger resolution screenshot"></a></p>
<p>The column will populate correctly, i.e.:</p>
<pre><code>=SUM(A1+B1)
=SUM(A2+B2)
=SUM(A3+B3)
... etc.
</code></pre>
<hr>
<p><em>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!</em></p>
https://ask.libreoffice.org/en/question/160953/how-to-add-each-line-for-column-a-and-column-b-and-place-the-answer-in-column-c-for-each-line/?comment=160959#post-id-160959Thank you David...works perfectly and so simple!Wed, 18 Jul 2018 01:05:02 +0200https://ask.libreoffice.org/en/question/160953/how-to-add-each-line-for-column-a-and-column-b-and-place-the-answer-in-column-c-for-each-line/?comment=160959#post-id-160959