Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 17 Jul 2018 23:22:15 +0200=SUM(J23/(G23-H23)) for a whole column?https://ask.libreoffice.org/en/question/160599/sumj23g23-h23-for-a-whole-column/Can I perform this SUM for a whole column without entering in each line number manually? Is there a simpler way to do it if not?
Clarification:
I would like to have a fourth column that has the value of the formula for each line (e.g. K23 would be the result of the above formula).Fri, 13 Jul 2018 18:09:07 +0200https://ask.libreoffice.org/en/question/160599/sumj23g23-h23-for-a-whole-column/Answer by hjek for <p>Can I perform this SUM for a whole column without entering in each line number manually? Is there a simpler way to do it if not?</p>
<p>Clarification:</p>
<p>I would like to have a fourth column that has the value of the formula for each line (e.g. K23 would be the result of the above formula).</p>
https://ask.libreoffice.org/en/question/160599/sumj23g23-h23-for-a-whole-column/?answer=160601#post-id-160601If you want to sum a whole column, e.g. column A, enter `=SUM(A:A)`. If you want to divide the sum of column J by column G subtracted by column H, enter `=SUM(J:J)/(SUM(G:G)-SUM(H:H))`.Fri, 13 Jul 2018 18:26:44 +0200https://ask.libreoffice.org/en/question/160599/sumj23g23-h23-for-a-whole-column/?answer=160601#post-id-160601Answer by Mike Kaganski for <p>Can I perform this SUM for a whole column without entering in each line number manually? Is there a simpler way to do it if not?</p>
<p>Clarification:</p>
<p>I would like to have a fourth column that has the value of the formula for each line (e.g. K23 would be the result of the above formula).</p>
https://ask.libreoffice.org/en/question/160599/sumj23g23-h23-for-a-whole-column/?answer=160947#post-id-160947Depending on what is meant by "for a whole column", @hjek's answer may apply; or, as I suspect (based by your "I would like to have a fourth column that has the value of the formula for each line"), you could mean simply how to copy the formula to all cells in a column.
Then, you can enter the formula to, say, K23 (as you show); then copy the **cell** (not the text in cell!) - single-click to another cell first, then single-click back to K23, making sure that you are not editing the formula, then `Ctrl`+`C`; then select all the cells in the column (or - preferrable - a subrange adjacent to your data) - by clicking with mouse on the column's header, or by putting cursor to last cell and using `Shift`+`Ctrl`+`↑`, or by entering the range (K:K or K1:K123) into Calc's Name Box at top left corner of the sheet; then paste: `Ctrl`+`V`.
By the way: the formula `=SUM(J23/(G23-H23))` is equal to this simplified formula: `=J23/(G23-H23)`.Tue, 17 Jul 2018 23:22:15 +0200https://ask.libreoffice.org/en/question/160599/sumj23g23-h23-for-a-whole-column/?answer=160947#post-id-160947