Defining range using cell value



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. 

My gnumeric version is 1.6.1. 

Thanks
Berthold
-- 
berthold xn--hllmanns-n4a de / <http://höllmanns.de/>
bhoel web de                 / <http://starship.python.net/crew/bhoel/>




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]