Adding a Range of Cells Using The TOTAL() Function
Use the TOTAL function in the last cell in the column to total a range of cells.
- Position the insertion point in the total cell.
- Enter the TOTAL calculation on the Equation bar.
Notes
-
The TOTAL function relies on cell numbers. For example, if using the function TOTAL(c1..c9) and cell number c8 is in a different part of the document, it will also be included in the total. To exclude specific cells from the range, cells you do not want to be included in the total must be renumbered. Also, if you add a new cell, its cell number must be within the range specified in the TOTAL function or it will not be included in the total. An alternative is to use sum groups, which function independently of cell numbers. How?
-
If the total function occurs within a table, and if a row is inserted between the last entry in the total calculation and total row, the total calculation automatically updates for the new row added. For example, if the cells look like this:
A1
A2
total(a1..a2)
adding a row between A2 and the total changes the formula to total(a1..a3). However, adding a row updates the total only if the row above the inserted row was actually included in the total. For example, if the cells look like this:
A1
A2
A3
total(a1..a2)
adding a row between A2 and the total does not update the total.
Likewise, deleting a row from a totaled group of cells updates the total as well. If the cells look like this:
A1
A2
A3
total(a1..a3)
deleting row A3 will update the calculation to total(A1..A2)
