Ok, here's my problem. I would like an eash way of copying the sum formula across row B, each one with sheet number references corresponding to row A. ie. B1 is suming Sheet1, B2 is summing Sheet2, B3 is suming Sheet3. I tried something like =sum(Sheet&A1) and copy across row B but that doesn't work. Any ideas? Thanks.
Oh, I got posting all f up. Here's what it should be I would like to copy the sum formula across Row 2 referencing to the Sheet number in Row 1. ie. A2 is suming Sheet1, B2 is suming Sheet2, C2 is suming Sheet3.
Works great! Thanks. Now, actually my reference worksheets are in another workbook. If I don't have that workbook open first, I'll get a #REF error. Is this the effect of INDIRECT? If that's the case, does that mean I'll just have to copy the suming formula and manually changing the sheet names? The reason for this is that some of the users don't have the access to the reference workbook.