| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif only visible cells (filtered)
I have a few columns where I need to count the number of "Y", "N",
"?", and blank. At the top of my spreadsheet I added 4 rows, and at the top of each of the columns, I have the following (see below). This is counting ALL cells. I have several custom views set to view various filtered populations of this group of people (different affiliations - in column C if it matters). I need to see only the number for the visible cells. I've been fooling around with the SUBTOTAL function, but I can't get it to work. =COUNTIF(I5:I200,"Y") =COUNTIF(I5:I200,"N") =COUNTIF(I5:I200,"?") =COUNTIF(I5:I200,"") Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy visible cells on Filtered data | Excel Discussion (Misc queries) | |||
| count if on Visible - Filtered | Excel Worksheet Functions | |||
| How do I only delete/clear the visible cells in a filtered list? | Excel Worksheet Functions | |||
| Help to adapt Formula syntax to work with Visible Filtered Cells | Excel Worksheet Functions | |||
| average of visible cells in a filtered range | Excel Worksheet Functions | |||
Threaded Mode
