Remember there is also the '$' to fix the range to either a row or a cell. In the event you move your range, it will stick to the initial cell.
Example: $A11 -> will stick to column A A$11 -> will stick to row 11 $A$11 -> will stick to both column A and row 11. On 7/8/14, Martin Groenescheij <mar...@groenescheij.com> wrote: > > 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 >> > > -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
