Re: Defining range using cell value

[bhoel despammed com (Berthold Höllmann)]

"Andreas J. Guelzow" <aguelzow taliesin ca> 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
-- 
berthold xn--hllmanns-n4a de / <http://höllmanns.de/>
bhoel web de                 / <http://starship.python.net/crew/bhoel/>