TheJacobsDad
New Member
Hi everyone,
I hope someone might be able to help me out.
I have a workbook with several sheets detailing project info and one summary sheet.
On the summary sheet in cell A10 I type the project number (Which is the same as the corresponding sheet name) and when I have typed in the project number I want my formula to sum the the cells referenced on that sheet and display on my summary
So for example in the summary sheet in Cell A10 I type 45566 (Project Number) the formula will then reference this sheet using the indirect function and return me the cell values
I am trying this
=SUM(INDIRECT("'"&A10&"!"&"AN$6:AN$7",(INDIRECT("'"&A10&"!"&"AN$23",(INDIRECT("'"&A10&"!"&"AN$26:AN$29",(INDIRECT("'"&A10&"!"&"AN$31",(INDIRECT("'"&A10&"!"&"AN$33"))))))))))
And when I evaluate it appears to determine the sheet name correctly but I still get #REF
I hope someone might be able to help me out.
I have a workbook with several sheets detailing project info and one summary sheet.
On the summary sheet in cell A10 I type the project number (Which is the same as the corresponding sheet name) and when I have typed in the project number I want my formula to sum the the cells referenced on that sheet and display on my summary
So for example in the summary sheet in Cell A10 I type 45566 (Project Number) the formula will then reference this sheet using the indirect function and return me the cell values
I am trying this
=SUM(INDIRECT("'"&A10&"!"&"AN$6:AN$7",(INDIRECT("'"&A10&"!"&"AN$23",(INDIRECT("'"&A10&"!"&"AN$26:AN$29",(INDIRECT("'"&A10&"!"&"AN$31",(INDIRECT("'"&A10&"!"&"AN$33"))))))))))
And when I evaluate it appears to determine the sheet name correctly but I still get #REF