Spread Sheets issues.URGENT HELP PLEASE

[Andrea Madott <am...@royallepage.ca>]

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

Re: Spread Sheets issues.URGENT HELP PLEASE

[Alexandro Colorado <jz...@oooes.org>]

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 <Ma...@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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Spread Sheets issues.URGENT HELP PLEASE

[Martin Groenescheij <Ma...@Groenescheij.COM>]

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
>