» Summing the Visible Filtered List Values in Excel 2007
CATEGORY - Excel Filter
VERSION - Microsoft 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+=>.
Or
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.
Book Store:
Recommended Books:
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Definitive Guide to Excel VBA
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
No comments have been submitted.
