Subtotaling Numbers

To find the subtotal of numbers in a column:

  1. Select the cell where you want your subtotal to appear. Note that only the values ABOVE this cell (and, in the same column) will be subtotaled. Values that have already been used in a subtotal will NOT be included. Labels, function results, and empty cells will be given a value of zero.

  2. Go to the Data menu, and click Subtotal Above Nos. Or, if you are in Easy Mode, click the Subtotal Above Numbers button (in Advanced Mode, click the icon with a blue sigma symbol and yellow line).

  3. The numbers in the column will be subtotaled. Subtotal =, followed by the subtotal, should appear in the cell you selected. Note that this subtotal is a value, and thus, can be used in calculations; however, it will not be included in row and column totals.

Note: If ######### appears in the subtotal cell, the column is not wide enough. Increase the column width, and your subtotal will be visible.