how to calculate across sheets
Hi. I have a Numbers document with multiple sheets. How can I calculate the subtotals from each sheet in one cell on the last sheet?
Thanks
On the last sheet, start typing the formula by typing the equal sign "=", then click the first cell (on the other sheet) you want to total, then click the next cell (on another sheet), then click the last cell (*** yet another sheet), then type "enter"
Numbers automatically includes the "+" for you