INDIRECT Function problem

Originally Posted by robhargreaves

Hi I am trying to use the indirect function -

Here is my formula

=SUM(INDIRECT('Data'!"AM"&B21&":AM"&G21))

if I explicitly enter the row numbers into the formula it looks like this

=SUM('Data'!AM292:AM298)

but as B21 in the sheet containing the formula contains 292 and G21 contains 298 and these change I would like to use the INDIRECT function to return the sum and not have to alter the formula.

I am sure it is the speech marks or the quotes I have wrong but I cant work out which ones. Anyones help much appreciated.

Rob

Hi,

Try

=SUM(INDIRECT("Data!AM"&B21&":AM"&G21))

Let me know how you go
---

Originally Posted by robhargreaves

Thanks I had to alter it a bit but it was nearly there... this is what i used...

=SUM(INDIRECT("'Data'!AM"&$B$21&":AM"&$G$21))

Rob

ok - not sure why you wouild need quote (') around a Sheetname that contains no spaces, but good to see that you have it working, and thanks for your response

---