Numbers: sum function
Hi, I would need to know if there is a function that allows me to sum values that are in different sheets. Thanks!
MacBook Pro 15″
Question marked as
To sum cells A1 from both sheets:
=Foglio 1::Tabbela 1::A1 + Foglio 1-1::Tabbela 1::A1
or
=SUM(Foglio 1::Tabbela 1::A1; Foglio 1-1::Tabbela 1::A1)
If the formula is in one of those tables, it will simplify itself and remove the sheet and table name from the one cell reference. If a formula is referencing a cell in the same table, all it needs is the cell address (A1, B5, etc.). If it is referencing a cell in a different table on the same sheet it needs the table name and cell address (such as Table 2::C7). If it references a table on another sheet it needs the sheet name, table name, and cell address.