Make grand total of subtotals in Numbers
Make grand totals of subtotals in Numbers
Make grand totals of subtotals in Numbers
Just total the whole column containing the subtotals. This assumes the subtotals have been calculated using the Categories or Smart Categories feature, and are in 'category cells, not in cells in numbered rows in the table.
SUM(D) will total the values in all of the non-header, noon footer cells in the column. SUM assigns zero as the value of cells containing text, so those cells won't affect the sum. SUM(D) and other formulas using full column references cn be placed in a cell in a Header or Footer row of the column they are summing without issue, but will return a self-reference error if placed in a body cell of the same column.
Regards,
Barry
Just total the whole column containing the subtotals. This assumes the subtotals have been calculated using the Categories or Smart Categories feature, and are in 'category cells, not in cells in numbered rows in the table.
SUM(D) will total the values in all of the non-header, noon footer cells in the column. SUM assigns zero as the value of cells containing text, so those cells won't affect the sum. SUM(D) and other formulas using full column references cn be placed in a cell in a Header or Footer row of the column they are summing without issue, but will return a self-reference error if placed in a body cell of the same column.
Regards,
Barry
Using the 'Categories' template at File > New in your menu:
I click in the cell, then select the entire Column E in Table 1. Numbers automatically knows you want the sum of all the body cells.
In the formula editor you can also choose the sum of the subtotals, which gives you the same result:
SG
Make grand total of subtotals in Numbers