Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Summing the Visible Filtered List

CATEGORY: Summing
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

Summing the Visible Filtered ListSumming the Visible Filtered ListSumming the Visible Filtered List

Summing the Visible Filtered List
Rate this tip
12 34 5
  RATING: 4.11
  VIEWS: 19618
  No comments have been submitted.


REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


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.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation