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
Desperate for help..