indirect reference to a formula?
 

can i enter a formula on on 1 worksheet, and then refference it on the 2nd,
as indirect(), with the intentions of having it actually calculate the
refferencing worksheet?

ex:
sheet1, A9 contains: = sum(A1:A8)
sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the sum
of cells A1:A8 ON SHEET2 being displayed in sheet2, F30

thanks in advance,
mark

indirect reference to a formula?
 

All you need is:

=Sheet1!A9



--
Gary's Student


"mark kubicki" wrote:

can i enter a formula on on 1 worksheet, and then refference it on the 2nd,
as indirect(), with the intentions of having it actually calculate the
refferencing worksheet?

ex:
sheet1, A9 contains: = sum(A1:A8)
sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the sum
of cells A1:A8 ON SHEET2 being displayed in sheet2, F30

thanks in advance,
mark

indirect reference to a formula?
 

i need to use the indirect refernce because of a row insertion thing that
happens...


"Gary''s Student" wrote in message
...
All you need is:

=Sheet1!A9



--
Gary's Student


"mark kubicki" wrote:

can i enter a formula on on 1 worksheet, and then refference it on the
2nd,
as indirect(), with the intentions of having it actually calculate the
refferencing worksheet?

ex:
sheet1, A9 contains: = sum(A1:A8)
sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the
sum
of cells A1:A8 ON SHEET2 being displayed in sheet2, F30

thanks in advance,
mark

indirect reference to a formula?
 

No, you can't use indirect in that way to change which sheet the formula
=sum(A1:A8) refers to.

I think the closest you could come is

in A9 of sheet1

=sum(indirect(Sheet2!B1 & "!A1:A8"))
where B1 on sheet2 contains the word Sheet2

--
Regards,
Tom Ogilvy


"mark kubicki" wrote:

i need to use the indirect refernce because of a row insertion thing that
happens...


"Gary''s Student" wrote in message
...
All you need is:

=Sheet1!A9



--
Gary's Student


"mark kubicki" wrote:

can i enter a formula on on 1 worksheet, and then refference it on the
2nd,
as indirect(), with the intentions of having it actually calculate the
refferencing worksheet?

ex:
sheet1, A9 contains: = sum(A1:A8)
sheet2, F30 contains: =indirect('sheet1'!A9) 'with the intention of the
sum
of cells A1:A8 ON SHEET2 being displayed in sheet2, F30

thanks in advance,
mark