Spreadsheet question

[Canadian Helmet]

I have been out of the loop for a few years (3) with regards to tracking my spending and other good personal financial practices.  I am getting back into it.  I use excel or LibreOffice for my spreadsheets tracking. 

Where my problem is happening is that my items are not being totaled up with my drop down menu.  I even copied and paste from an older working spreadsheet and the totals are not adding up like they used to.

Any help would be appreciated.  Thanks in advanced.

[yachi]

Maybe your costs came is as text for some reason?  Test if they can be added.  In any cell type  =S49+S50 , and see if it can correctly add them to $1,110.61

[yachi]

Your formula still looks right.  Another option is maybe it's not configured to auto refresh.  Press Shift+Ctrl+F9 to recalculate all formulas.

[Canadian Helmet]

Thanks for the tips.  It's still not working.  I think it might be because I am not using excel, but a LibreOffice Calc.  I am going to try to confirm this today.
I got a new computer and it doesn't have excel and I don't want to pay for it again because it is subscription based now.

[Canadian Helmet]

Figured it out... I was copying from my credit card companies spreadsheet and it was putting an apostrophe before the $ symbol.