This article describes how to use the SUBTOTAL function with AutoFiltered lists in Microsoft Excel 2000.
You can use the SUBTOTAL function to dynamically count or display other information about records in a list that has AutoFilter turned on. When you change the AutoFilter criteria, the results of the SUBTOTAL function also change.
For more information about the SUBTOTAL function, click Microsoft Help on the Help menu, type subtotal worksheet function in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
You can also use a macro to get a similar result. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
213275 XL2000: Macro to Count the Number of Records Returned in an AutoFiltered List