1. ## Linest (2000)

The attached file calculates heat consumption (Mcf) per customer as a function of heating degree days (HDDs). What I would like to do is print out the Linest information on a separate worksheet, but for some reason I can't seem to get it. Any helpers?
Thanks.

2. ## Re: Linest (2000)

Have you tried Cut & Paste or Copy & Paste ?

If that doesn't do what you want, please explain what exactly you want to accomplish.

3. ## Re: Linest (2000)

What I am trying to accomplish is to print out the various statistics associated with the Linest function, such as b, r-squared, t-factors, degrees of freedom, etc., on a separate spreadsheet.
Thanks.

4. ## Re: Linest (2000)

But of what? Your RS sheet contains lots of formulas involving LINEST referring to almost one hundred different ranges.

5. ## Re: Linest (2000)

The formula in K150

6. ## Re: Linest (2000)

The formula =LINEST(RS!D\$29149,RS!F\$29:F149,TRUE,TRUE) entered into A1:B5 on a new sheet as an array formula (confirm with Ctrl+Shift+Enter) will do what you ask.

See the attached workbook. A1:B5 contains the array formula; D1:E5 explains the meaning of each cell - see the online help on LINEST for more info.

7. ## Re: Linest (2000)

Thanks, Hans. That is exactly what I was looking for. The help section on Linest is very confusing!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•