using slope function with non contiguous cells

F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the slope function with non contiguous cells 6
Complex 2 table formula 5
Function similar to TREND that interpolates lin. between data poin 2
optimization 1
Indirect function 2
COUNTIF Non Contiguous Cells Q 3
Slope??? help please!!! 1
SUMIF formula with non contiguous cells 2

Top