# SUM Difficult Formatting Directions

I am trying to get a checking account balance, adding positive and negative amounts to the previous balance to see what I should have at the end. In trying to get the SUM function in the correct format, I lost a whole column of figures and have to start a new spreadsheet. Having taken care of that, I am not getting the results I want. I was able to solving my current reconciliation problem; but I would still like to setup the document. After going online to obtain formating directions, they are not understandable. I am getting unreadable results. I have all my debits and credits in Column C showing debits as negative numbers. Next to each transaction I want a running balance in Column D. Thank you.This is version 7.0.2.2 on Windows 7 64-Bit. C:\fakepath\CommunitySample.xls

Formatting should not be a problem so long as all cells involved in the SUM are formatted as numbers. Are you copying the numbers from a website or someone else's spreadsheet? It would help a lot if you gave us an example of the problem you are having.

I started with a balance out of my checking account and tried to total all of the transactions since. For the =SUM formula I used cell locations. The formula is in the column where I want the changing balances. Results are not showing as numbers. All cryptic. The function is not working.

Can you provide a sample spreadsheet that shows the problem? Edit your question and use the paperclip to attach your document.

Hello

Does the SUM function applies to a range of cells including the location of the SUM function ?

Edit the description of your question and append a sample spreadsheet without sensitive data.

In cell D2, I tried to enter the formula =SUM(C3:C20, D2:D19) although my actual register goes to almost 40 entries. For the sample I did not enter the formula so that the spreadsheet would be free of whacky codes. Good luck.

There is an answer posted that does not tell me what to do.

If you are copying and pasting the numbers from your on-line bank statement, you must format the numbers in LibreOffice as Numbers; otherwise the "numbers" will probably be treated as Text, producing nonsense results.

Also, those "all cryptic" notations that you are trying to avoid are actually error messages from LibreOffice, trying to tell you what is wrong. Please tell us what the cryptic notations are, or give us an actual example.

Are the "cryptics" a series of # ? If so, this means that the column width is not large enough or the size of the font too large.