» Summing the Visible Filtered List
To total the values in the visible filtered rows, use the SUBTOTAL function:
1. Filter the List by selecting any criteria.
2. Select a cell in the List area and press Ctrl+Shift+ * (in Excel 2003, press this or Ctrl+A) to select the Current Region/List.
3. Press Alt+=.
Click the AutoSum icon (sigma).
4. The SUBTOTAL function is automatically entered below the values in each column.
The SUBTOTAL function has been expanded in Excel 2003.
The digit 9 in the first argument of the SUBTOTAL function is for function number 9 (the SUM function) –see the table below for a list of the function numbers you may use.
The second column in the table below is new in Excel 2003. When using numbers from 1 to 11, the SUBTOTAL function also returns values from hidden rows. When using the numbers from 101 to 111, the SUBTOTAL function returns values from visible rows only.
|Screenshot // Summing the Visible Filtered List|