ROW-function does not work with INDIRECT-function

**Jonathan78** · 07-08-2016, 10:46 AM

Hello all,

The following formula works:

=SLOPE(INDIRECT("R"&10&"C7:R"&10&"C10";FALSE);INDIRECT("R"&9&"C7:R"&9&"C10";FALSE))

but if I replace the row number with ROW() it does not.

=SLOPE(INDIRECT("R"&ROW()&"C7:R"&ROW()&"C10";FALSE);INDIRECT("R"&9&"C7:R"&9&"C10";FALSE))

I tried both formulas on the 10th row

All help welcome

**Special-K** · 07-08-2016, 11:21 AM

UPDATE: No, I was right, I'm getting an error copying both formulas into row 10

Removing the SLOPE and INDIRECT...

first formula results in

R10C7:R10C10

second formula results in

R10C7:R10C10

Perhaps you can't dow row/column in an INDIRECT ? Maybe it has to be a range of cell references ?

**Jonathan78** · 07-08-2016, 11:26 AM

Hello Special-K

Why should it be ignored?

**Special-K** · 07-08-2016, 11:31 AM

I meant ignore my reply.
I thought I found an error.
Then I didn't think that.
But now I do again (see my first reply).

I'm still getting errors copying those formulas into row 10.

Further
if you put the results of R10C7:R10C10 in an INDIRECT it comes up with a #REF error.
Maybe you have to set the option for row/column referencing?

**Jonathan78** · 07-08-2016, 11:42 AM

The formulas are OK except for the ROW() part.
See enclosed example

**Jonathan78** · 07-08-2016, 11:50 AM

Found it out already
ROW seems to return an array and to get its first element I should have used INDEX(ROW(),1)

The following worked
=SLOPE(INDIRECT("R"&INDEX(ROW(),1)&"C7:R"&INDEX(ROW(),1)&"C10";FALSE);INDIRECT("R"&9&"C7:R"&9&"C10";FALSE))

Thanks for your help Special-K