| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif within a filtered sheet
Hi
Range F3:F545 contains 0 or 1 Formula in F2 =COUNTIF(F3:F545,"0") this counts the number of 1's and works fine. Is it possible to count the number of 1's in a filtered list. So when filtered on the 0's, then F2 should display 0 Thanks George Gee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paseting filtered info into another sheet | Excel Discussion (Misc queries) | |||
| Filtered table using Countif | Excel Worksheet Functions | |||
| COUNTIF Function on filtered data | Excel Discussion (Misc queries) | |||
| countif only visible cells (filtered) | Excel Worksheet Functions | |||
| AutoSum on a filtered sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
