Mailing-List: contact users-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openoffice.apache.org
Received-SPF: pass (athena.apache.org: domain of acolorado@gmail.com
 designates 209.85.216.179 as permitted sender)
MIME-Version: 1.0
Sender: acolorado@gmail.com
In-Reply-To: <53BC1B1C.7040708@Groenescheij.COM>
References: 
 <CAGnmJiFjnWYHu2yVFLAQaQ7tGfhf8qt8GFR+OR+e4xgbn2TdHg@mail.gmail.com>
	<53BC1B1C.7040708@Groenescheij.COM>
Date: Tue, 8 Jul 2014 11:32:57 -0500
Message-ID: 
 <CAMK9kTghcEwRU4et7D-hW8=bbJ1MdV8V_HZra+rk00TJcaYgEA@mail.gmail.com>
Subject: Re: Spread Sheets issues.URGENT HELP PLEASE
From: Alexandro Colorado <jza@oooes.org>
To: users@openoffice.apache.org, Martin@groenescheij.com
Cc: amadott@royallepage.ca
Content-Type: text/plain; charset=UTF-8

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 <Martin@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