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.
or:
=sum(indirect(concatenate("B1:B",count(B:B)))
Andreas
--
Prof. Dr. Andreas J. Guelzow
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta
signature.asc
Description: This is a digitally signed message part
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
