| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula for filtered worksheet
I'm using excel 2000
I need a formula that will count the number of times Y appears in the range F4:F1000, but will change to reflect the number visible when the list is filtered I tried =COUNTIF(F4:F1000,"Y"), which returns the correct value, however when I filter the list the value from the above formula does not change I have tried =SUBTOTAL(3,F4:F1000) but this counts all entries in the range, not just the Y's Any help greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy name of filtered cell to another worksheet | Excel Discussion (Misc queries) | |||
| How do I combine filtered data from one worksheet to another? | Excel Discussion (Misc queries) | |||
| Totals in my filtered worksheet | Excel Discussion (Misc queries) | |||
| Formulas, for filtered worksheet | Excel Discussion (Misc queries) | |||
| Deleting filtered out data from a worksheet | Excel Worksheet Functions | |||
Threaded Mode
