iWork
Q: 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
Posted on Sep 19, 2016 5:17 AM
by Wayne Contello,Solvedanswer
iWork
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 (lon yet another sheet), then type "enter"
Numbers automatically includes the "+" for you
Posted on Sep 19, 2016 5:39 AM