SUM only selecting 1 cell

Using Libre Office Calc and trying to total cells in a column. I select the bottom cell for the total. Click the SUM symbol and then manually select all the cells in the column as it only selects the last one to be added. The formula; e.g: =sum(C5:C27) is correct so I click the tick in the toolbar but only the last cell number is shown in the total cell.

Normally, all values to be summed are displayed correctly immediately. If this is not the case, I suspect you have in between empty cells or cells with text.

But if you have created the formula manually by selecting the cells, a simple “Return” should be sufficient.

However, to know more, it would be helpful if you upload your file (just the column with the data) here.


This is how you can upload:
Click on the three dots or the pencil, or the edit icon under your initial question.
What’s available.
In the edit mode of the question, select the upload icon.
Select your file and click the Upload button.
Thank you very much.

Maybe only C27 is formatted as number.

Press Ctrl+F8 (menu View - Value Highlighting) to see the numbers in blue, and the text in black.

In the status bar usually you can see the sum of the values in the selected cells.

1 Like

NumericText.ods (18.0 KB)

Thank you all for your suggestions.
By going into each cell in the column I found that all but one cell had an apostrophe next to the number; eg: '1. The autosum therefore would not add these cells. I have no idea how it happened but it’s resolved now.
Thank you again.
DK

1 Like