Apache OpenOffice Community Forum

I am using a spreadsheet. In the column I am presently using there are two cells that wont include the figure in their cells in the final total. I hope you can understand my explanation. Can anyone help me? Many Thanks.
Norman

It may be that the content of those two cells is text. Try selecting the menu item View -> Value Highlighting. Numbers will then be blue, text will be black and the result of formulas will be green. Are the cells that are not included in the total black? If they are green, what is the formula?

If those cells are sums generated by the Auto-Sum function (looks like a sideways M) and the cell for the final total is also generated using the Auto-Sum, then it is a problem, but one that (looking at the code) seems to be intentional....ie: An auto-sum in a column will not, automatically, include an auto-sum already in the column.
This can be over-ridden on a cell by cell basis by editing the formula entered by the Auto-Sum button.
Aside from that, I second FJCC's suggestion that the cells contain text or formulas that generate text, rather than numbers or formulas that generate a numeric response.

The cells in question are all blue, no black, green for the total sum
Something went wrong since I/ve been using this spread sheet for a number of years with no problems.
Could it be the formula somehow went awry? All the other cells in the column are working.Norman

Without seeing your file it is hard to say what is happening. Can you upload the file and explain which cells are causing a problem? To do that, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.