using slope function with non contiguous cells

[fallowfz]

Is there a way to use non contiguous cells with the slope function?
Specifically, if y's and x's contain non contiguous values.

SLOPE(known_y's,known_x's)


A simple example...


x's y's
1 10
2 12
3 30
4 32
5 60
6 68


Where...
desired x's = 1, 3, 5
desired y's = 10, 30, 60


Thanks,


-Zack

 

[Jim Thomlinson]

Nope... The ranges must be contiguious...