» Summing the Visible Filtered List
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
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.




Book Store:
Recommended Books:
- Analysis of Financial Statements
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Monte Carlo Methods in Finance
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- The Interpretation of Financial Statements
No comments have been submitted.


