|
» Summing the Visible Filtered List
CATEGORY: Summing |
VERSIONS: All Microsoft Excel Versions |
|
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. |
| Screenshot // Summing the Visible Filtered List |
   |
|
RATING:
4.11
VIEWS: 19618 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Harry Potter and the Order of the Phoenix (Book 5)
- Microsoft Access Version 2002 Step by Step
- Accounting the Easy Way
- Financial Risk Manager Handbook, Second Edition
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Financial Reporting and Analysis (2nd Edition)
Related MS EXCEL TIPS:
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.
