If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I count rows in a filtered list when using AutoFilter?
I have a database list in Excel spreadsheet and use the AutoFilter to look at
selected items. How can I count the number of rows with data that are displayed when the worksheet is filtered, similar to SUBTOTAL does when a column has numbers in it? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Getting Count field to recognise rows with negative values in Exc. | hamish | Worksheet Functions | 2 | June 20th, 2005 05:06 AM |
filtering a list box using a filtered combo box | davidchadwick | New Users | 3 | May 27th, 2005 11:32 PM |
How do I get Excel to count identical rows in a list? | Ali Dennis | General Discussion | 1 | October 28th, 2004 04:05 PM |
Adding new rows to a list when Protection is on | Rolando | Worksheet Functions | 0 | May 5th, 2004 01:46 AM |
Counting Unique Elements of filtered list with Blank Cells | Peo Sjoblom | Worksheet Functions | 3 | December 19th, 2003 12:30 AM |