No version of LINEST permits missing values. For simple linear
regression, use SLOPE and INTERCEPT. If you need the statistics from
LINEST (or need more numerical stability in pre-2003 versions), see

http://groups-beta.google.com/group/...a03470e7a1c650

The formula for seb should be
seb = steyx*SQRT(...

For missing values, you can replace x arrays in the formulas with
IF(ISNUMBER(x)*ISNUMBER(y),x) and y arrays with
IF(ISNUMBER(x)*ISNUMBER(y),y) and array enter (Ctrl-Shift-Enter) the
formulas.

Jerry

Disco wrote:

> Hey Everyone,
>
> I'm trying to get a linear regression function to work and am having a
> lot of difficulty. I need the function to do a linear regression
> (LINEST) of 2 columns of data, but I need it to exclude 0s and blanks
> in the data(this is where I'm stuck). I've tried some of the
> suggestions I've seen here for the SUM and AVERAGE functions but it
> doesn't seem to be working with LINEST. Help
>
> - Disco