| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic count on an Autofiltered list
I have a large spreadsheet that has the Autofilter function engaged. I have
a summary section at the bottom of the sheet, and I want a Count section that will change to the appropriate count number when an filter is engaged. Example: I have 10 rows of data, composed of 4 occurences of A, 3 occurences of B, and 3 occurences of C. When showing All in autofiltered mode, the Count would show 10, however if I choose to view only A, then the count value would change to 4. I believe there is a simple formula to accomplish this but it escapes me. Help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of AutoFiltered records | Excel Worksheet Functions | |||
| Copy Results from Autofiltered List | Excel Worksheet Functions | |||
| How to identify text from a autofiltered list using formulas | Excel Worksheet Functions | |||
| Copying to an autofiltered list | Excel Discussion (Misc queries) | |||
| How to plot only visible autofiltered rows in a data list | Charts and Charting in Excel | |||
Threaded Mode
