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 www.ureach.com/yoda2u
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
Hi
I'm not too sure I understand either but this is how you would total cells on Sheets A to Sheets Z
=SUM(A:Z!M92:BN92)
Dave
OzGrid Business Applications
