Numbers formula for adding up several spreadsheet totals

One way would be to combine all those tables into one table on one sheet, with an additional column for the "category". Then the running total would include all the entries.

Another way would be to put a footer row at the bottom of each of those tables and, in that row, have the running total. No data gets entered into this row, only a formula that calculates the running total. When you need new rows, they go above the footer. In a cell on a summary table you would add up all those cells like this:

=Food::Table 1::G20 + Home::Table 1::G31 + Car::Table 1::G25 +...

Where G# is the cell in the table that has the running total for that category. I assumed your sheets are the category names and the table on each sheet is the default table name of Table 1 and I picked column G as your running total column.

Krankywitch wrote:

I'll have to go find a learning resource for adding a footer row - sounds interesting.

Hi KW,

Click on the row letter of the last row in a table.

Regards,

Ian.

"Way too many categories" makes option 2 sound bad, too.