On Jul 11, 4:23 am, Lori wrote:
Maybe try entering this using {Ctrl+Shift+Enter}:

=SLOPE(IF(ISNUMBER(B2:H2),B2:H2),IF(ISNUMBER(B2:H2 ),B1:H1))

slope/intercept/forecast ignore non-numeric data (unlike linest/trend).


Many thanks for your help. I'll give it a try.

Cheers, Mark