Summing the Visible Filtered List Values in Excel 2007

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+ * or press Ctrl+A) to select the List.
3. Press Alt+=>.
Select Formulas -> AutoSum (in Function Library Group).

The SUBTOTAL function is automatically entered below columns containing values in each column.

The digit 9 of 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

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.