indirect reference to a formula?

M

mark kubicki

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
 
M

mark kubicki

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

Guest

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
 

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 INDIRECT function across multiple worksheets 1
INDIRECT Syntax 1
How to delete ALL cells containing the same data 1
How to calculate % in summary sheet from cell A9 in multiple sheet 3
do until loop 2
Copying Sheet1 to Sheet2 in a certain pattern 6
How to Use Relative Reference in Array Formula 4
Help with an IF Formula 1

Top