I do not follow exactly what you are saying (too little sleep etc) but I think what you are looking for is this.
If you have four sheets called Summary, Sheeet2, Sheet3, Sheet4 (not 2, 3, 4) then ------ In cell A1 of the summary sheet enter this formula =SUM(Sheet2:Sheet4!A1) That will sum the all the values from cell A1 from the three detail sheets and show the result in cell A1 of the summery sheet. There are some things you can do if you want to make sure that this always works and does not require the person using it to know what not to do. If you want more help let me know. Chrissy. ----- Original Message ----- From: "John" <[EMAIL PROTECTED]> To: "Multiple recipients of list offtopic" <[EMAIL PROTECTED]> Sent: Friday, July 11, 2003 12:19 PM Subject: [DUG-OFFTOPIC]: Excel > Hi all, > > > Does anybody know how to solve this reference problem in Excel? > > I have multiple sheets. The first sheet is a summary of all other sheets. > > The Sum-sheet has two columns with the following cell contents: > > Sheet # Value > --------------------- > 2 ='2'!$C$4 value from sheet 2 of cell C4 > 3 ='3'!$C$4 value from sheet 3 of cell C4 > 4 ='4'!$C$4 value from sheet 4 of cell C4 > etc. > > Is there any way of using the sheet value (column 1) in the second column's > formula? > > Something like this: =SHEET($A$1)!$C$4 where $A$1 is the first column. > > > Thanks for any help. > > John. > > --------------------------------------------------------------------------- > New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe offtopic" > Web Archive at: http://www.mail-archive.com/offtopic%40delphi.org.nz/ > --------------------------------------------------------------------------- New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe offtopic" Web Archive at: http://www.mail-archive.com/offtopic%40delphi.org.nz/
