Select cell A111 and if it shows a *`* in the formula bar before the value it is defined as text.
Just delete the ` and it should give you the correct results.
On 9-7-2014 2:12, Andrea Madott wrote:
I'm having problems with my spread sheet. I highlight a row to sum and it adds everything but the first line. I tally each months expenses into a total and then use that total as the basis of next month's opening balance but Open Office is not allowing that. If I highlight and auto sum lines 110 to 123, the formula shown in the total cell reads =SUM (A111:123) and ignores the first cell. Please help, just converted to open office and now all my accounting is wrong. Regards, *Andrea Madott* *Sales Representative* *Helping you is what we do* *Royal LePage Gale Real Estate, Brokerage* *105-383 Parkdale Avenue, Ottawa, ON K1Y 4R4* *(613) 723-5300 <%28613%29%20723-5300> office (613) 614-5433 <%28613%29%20614-5433> direct* *"**Oh by the way, I'm never too busy for your referrals" * Follow me on Twitter! https://twitter.com/@Andreamadott
