Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting the number of cells meeting conditional formating criteria
Hi,
Is it possible to count the number of cells (most often in a filtered) range that are "activated" by meeting the condional formatting formula? In my case, I'm using colours to indicate the number of rows that meet the criteria. I know the number of rows in the filtered range n (thanks to this forum). I find in my analysis, I am always manually counting the incidence of meeting criteria and express the quantity as a percentage of n and wondered if this can be achieved programatically. I only need to count the incidence and have the skills to do the rest of my task objective. regards Jeff |
#2
|
|||
|
|||
Can you use the same criterion in a conditional formula?
For instance, if your CF is Formula is =A110 then you'd use =COUNTIF(A:A,"10") There's no direct way to count conditionally formatted cells. In article , "Jeff" wrote: Hi, Is it possible to count the number of cells (most often in a filtered) range that are "activated" by meeting the condional formatting formula? In my case, I'm using colours to indicate the number of rows that meet the criteria. I know the number of rows in the filtered range n (thanks to this forum). I find in my analysis, I am always manually counting the incidence of meeting criteria and express the quantity as a percentage of n and wondered if this can be achieved programatically. I only need to count the incidence and have the skills to do the rest of my task objective. regards Jeff |
#3
|
|||
|
|||
Thanks for this. Does this mean I will have to create a column for a
true/false to criteria and count them in the filtered range? The real value of this forum is people come up with some solutions that the Excel sites say can't be done (like counting the number of filtered rows). I marvel at the skills and expertise of you contributors. "JE McGimpsey" wrote in message ... Can you use the same criterion in a conditional formula? For instance, if your CF is Formula is =A110 then you'd use =COUNTIF(A:A,"10") There's no direct way to count conditionally formatted cells. In article , "Jeff" wrote: Hi, Is it possible to count the number of cells (most often in a filtered) range that are "activated" by meeting the condional formatting formula? In my case, I'm using colours to indicate the number of rows that meet the criteria. I know the number of rows in the filtered range n (thanks to this forum). I find in my analysis, I am always manually counting the incidence of meeting criteria and express the quantity as a percentage of n and wondered if this can be achieved programatically. I only need to count the incidence and have the skills to do the rest of my task objective. regards Jeff |
#4
|
|||
|
|||
Not necessarily - the example I gave could be done in one cell. What is
your conditional? In article , "Jeff" wrote: Thanks for this. Does this mean I will have to create a column for a true/false to criteria and count them in the filtered range? |
#5
|
|||
|
|||
I apologise for not getting back. I solved the problem (thanks) and forgot
I'd asked that query :- ( sincerely Jeff "JE McGimpsey" wrote in message ... Not necessarily - the example I gave could be done in one cell. What is your conditional? In article , "Jeff" wrote: Thanks for this. Does this mean I will have to create a column for a true/false to criteria and count them in the filtered range? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return number of cells filled | New Users to Excel | |||
cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) |