I'm working with 3 sheets. The 3rd sheet will just show grand totals that are the sum of cells on sheets 1&2. How do I write a sum function on Sheet 3 to show the sum of each of these cells?
iMac, Mac OS X (10.7.2), iPad2, iPad, iPhone4, Macbook, G4
If I follow you (and that is a big if), its basically just a SUM function using the span of cells on the third sheet. If that is not what you are looking for, perhaps you could provide a little more detail.
Basically you provide the Sheet and Table names as well as the cell designation as the data reference:
=SUM('Sheet 1' :: 'Table 1' :: B2+'Sheet 2' :: 'Table 1' :: B2)
When you add the formula, you can navigate to the other sheets to select the specific cell
To clarify: I'm working with iWork Numbers-Beta on an iMac. I have no problem referencing cells in the SUM function when they're cells on the same sheet. In my case I've got two sheets that have cell values I'd like to SUM in a cell on Sheet 3. How do I reference these cells on disparate sheets when I fill out the SUM function parameters?
Can you do the same with values from different numbers documents ?
No, only within the same file.
THANK YOU
How do I sum across multiple sheets
