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+=.
OR
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.
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.