MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help...More than one Sheet cell referencing

Posted by pbroderick on April 23, 2001 9:50 AM

I am trying to figure out the correct formula to do this:
Sheet 1 has a formula to add dollar amounts (=+sum(M92:bn92).
I've created Sheets A-Z (renamed). Each Alphabetical sheet will have an account
with a total on it. How to I link the Alphabetical sheet
totals to the main total on the Main sheet? The cell on the main
sheet has the following which I added the sheet2!...=+sum(M92:bn92)sheet2!E6
Where E6 on sheet 2 has the total I want added to the main sheet, however this does not work
at all.

Desperate for help..

Posted by David on April 23, 2001 12:58 PM

CAn you try rephrasing the question I am not understasnding

Posted by Bart on April 23, 2001 1:16 PM

Dear pbroderick

Your syntax is wrong.

Go to
Click Filing Cabinet. Wait a moment
Click Excel Posting. Wait a moment
Click and download example: All Sheet Sum.

Posted by Dave Hawley on April 23, 2001 11:45 PM


I'm not too sure I understand either but this is how you would total cells on Sheets A to Sheets Z



OzGrid Business Applications