openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexandro Colorado <...@oooes.org>
Subject Re: Spread Sheets issues.URGENT HELP PLEASE
Date Tue, 08 Jul 2014 16:32:57 GMT
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


Mime
View raw message