Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 19 Mar 2019 08:21:53 +0100Equal Sign Sum of Cells Doesn't Workhttps://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/To get the sum of a series of numbers in cells in a column, I place my cursor inside the cell below the series, then I click on the Equal sign (=) up on the tool bar.
Then I place my cursor in the top cell of the series and drag down to include all the cells.
Instead of getting the sum, I get #VALUE!
When I look at the field for the cell in the tool bar, I see =A1:A8, and that's what shows in the cell when I place the cursor in the field. But when I hit Enter, I again get #VALUE!
What am I doing wrong?Tue, 19 Mar 2019 04:12:33 +0100https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/Answer by Ratslinger for <p>To get the sum of a series of numbers in cells in a column, I place my cursor inside the cell below the series, then I click on the Equal sign (=) up on the tool bar. </p>
<p>Then I place my cursor in the top cell of the series and drag down to include all the cells. </p>
<p>Instead of getting the sum, I get #VALUE!</p>
<p>When I look at the field for the cell in the tool bar, I see =A1:A8, and that's what shows in the cell when I place the cursor in the field. But when I hit Enter, I again get #VALUE!</p>
<p>What am I doing wrong?</p>
https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?answer=187389#post-id-187389Hello,
Do not use the `=` at all. Use the Sigma `Σ` symbol for Sum. The = is for formulas. Your current selection will result in `=Sum(A1:A8)`
Steps to Sum A1 thru A8:
- Select cell where the total is to appear.
- Select Sigma character from toolbar
- Select Cell A1 & drag down to cell A8
- Release mouse & hit enterTue, 19 Mar 2019 04:34:33 +0100https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?answer=187389#post-id-187389Comment by librenutz for <p>Hello,</p>
<p>Do not use the <code>=</code> at all. Use the Sigma <code>Σ</code> symbol for Sum. The = is for formulas. Your current selection will result in <code>=Sum(A1:A8)</code></p>
<p>Steps to Sum A1 thru A8:</p>
<ul>
<li><p>Select cell where the total is to appear.</p></li>
<li><p>Select Sigma character from toolbar</p></li>
<li><p>Select Cell A1 & drag down to cell A8</p></li>
<li><p>Release mouse & hit enter</p></li>
</ul>
https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?comment=187403#post-id-187403Got it, thank you very much!Tue, 19 Mar 2019 08:19:52 +0100https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?comment=187403#post-id-187403Answer by librenutz for <p>To get the sum of a series of numbers in cells in a column, I place my cursor inside the cell below the series, then I click on the Equal sign (=) up on the tool bar. </p>
<p>Then I place my cursor in the top cell of the series and drag down to include all the cells. </p>
<p>Instead of getting the sum, I get #VALUE!</p>
<p>When I look at the field for the cell in the tool bar, I see =A1:A8, and that's what shows in the cell when I place the cursor in the field. But when I hit Enter, I again get #VALUE!</p>
<p>What am I doing wrong?</p>
https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?answer=187388#post-id-187388(This is not the answer!)
Okay, I see that I neglected to click the SUM symbol.
So now I click the Equal then the SUM symbol while my cursor is in the cell below the series, then click in the top cell and drag through the cells in the series.
In the tool bar field, what shows is =SUM(A1:A8)
But in the cell below, the number that comes up is ZERO (0), even though the numbers in the series most definitely do NOT equal zero.
Now, when I go back to do it again, it gives me the number that is in the bottom cell of the series, not the sum of the series, even though the formula remains the same: =SUM(A1:A8).
What gives? Tue, 19 Mar 2019 04:33:28 +0100https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?answer=187388#post-id-187388Comment by librenutz for <p>(This is not the answer!)</p>
<p>Okay, I see that I neglected to click the SUM symbol. </p>
<p>So now I click the Equal then the SUM symbol while my cursor is in the cell below the series, then click in the top cell and drag through the cells in the series. </p>
<p>In the tool bar field, what shows is =SUM(A1:A8)</p>
<p>But in the cell below, the number that comes up is ZERO (0), even though the numbers in the series most definitely do NOT equal zero.</p>
<p>Now, when I go back to do it again, it gives me the number that is in the bottom cell of the series, not the sum of the series, even though the formula remains the same: =SUM(A1:A8).</p>
<p>What gives? </p>
https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?comment=187404#post-id-187404I see, I thought that selecting number in the formatting interface was all that I needed to do to convert cells to numbers. Thank you very much!Tue, 19 Mar 2019 08:21:53 +0100https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?comment=187404#post-id-187404Comment by Mike Kaganski for <p>(This is not the answer!)</p>
<p>Okay, I see that I neglected to click the SUM symbol. </p>
<p>So now I click the Equal then the SUM symbol while my cursor is in the cell below the series, then click in the top cell and drag through the cells in the series. </p>
<p>In the tool bar field, what shows is =SUM(A1:A8)</p>
<p>But in the cell below, the number that comes up is ZERO (0), even though the numbers in the series most definitely do NOT equal zero.</p>
<p>Now, when I go back to do it again, it gives me the number that is in the bottom cell of the series, not the sum of the series, even though the formula remains the same: =SUM(A1:A8).</p>
<p>What gives? </p>
https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?comment=187397#post-id-187397Your data in cells is not numbers, although looks like numbers (check with `View`→`Value Highlighting` (`Ctrl`+`F8`)). You need to convert to numbers - use `Data`→`Text to Columns...`, or see [this FAQ](https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data).Tue, 19 Mar 2019 06:58:38 +0100https://ask.libreoffice.org/en/question/187387/equal-sign-sum-of-cells-doesnt-work/?comment=187397#post-id-187397