Hello all, I've got a spreadsheet where I sum a range from another sheet, where that sheets name is specified by a cell on the current sheet.
=SUM(INDIRECT("'" & A3 & "'.A1:A10"))
Where A3 will have something like "Sheet2" in. This works fine until I insert or delete a row. It worked fine before I started using the INDIRECT() function, but now the it wont update the range. I sort of understand why, but can anyone tell me a way to use INDIRECT and still have the range updated when I insert or delete a row. Thanks Torben
|