"Andreas J. Guelzow" <[EMAIL PROTECTED]> writes:
> On Sat, 2006-24-06 at 21:22 +0200, Berthold Höllmann wrote:
>> I have a spreadsheet where I regular add lines with 14 columns. From
>> some of these columns I calculate SLOPE, INTERCEPT, or FORECAST. These
>> functions do not work using ranges as $A:$A that I can use in graphs.
>> These ranges are accepted, but the calculated values are wrong. I
>> tried using ADDRESS, but without sucess.
>
> perhaps something like
> =sum(indirect(concatenate("B1:B",A1)))
> where A1 contains the number of rows can help you too.
Great, yes, that works for me.
>
> or:
> =sum(indirect(concatenate("B1:B",count(B:B)))
Thanks
Berthold
--
[EMAIL PROTECTED] / <http://höllmanns.de/>
[EMAIL PROTECTED] / <http://starship.python.net/crew/bhoel/>
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
