jesse james wrote...

...

Slope works fine if you have data in A1:C1 that you want to

compare to A2:C2 ( =SLOPE(A1:C1,A2:C2) ). However, as soon

as you want to compare A1, C1 & E1 to A2:C2, Excel will not

accept the formula.

...

The general approach to converting multiple area ranges into a singl

array involves either INDIRECT or OFFSET.

=SLOPE(N(INDIRECT({"A1","C1","E1"})),A2:C2)

=SLOPE(N(OFFSET(A1,0,{0,2,4},1,1)),A2:C2)

The N() calls are *NOT* optional. INDIRECT and OFFSET when fed arra

first arguments return what appear to be arrays of range references. I

you enter their results into multiple cell ranges, Excel displays th

values in those ranges. However, you can't use their results directl

as intermediate array values in other expressions. Wrapping them insic

N() converts the array of range references to an array of the numeri

values of the top-left cell in each of the range references