| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count cf cells displaying condition 3
I have a range of cells that have conditional formats with conditions 1, 2
and 3. Is there a way to count cells that display condition 3? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count cf cells displaying condition 3
Use the count if function
=Countif(range,"3") "DAN" wrote: I have a range of cells that have conditional formats with conditions 1, 2 and 3. Is there a way to count cells that display condition 3? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count cf cells displaying condition 3
Show us condition No3 and someone will tell you how to count it
Mike "DAN" wrote: I have a range of cells that have conditional formats with conditions 1, 2 and 3. Is there a way to count cells that display condition 3? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count cf cells displaying condition 3
=ISNUMBER(MATCH(B5,$CI$3:$CI$51,0))
"Mike H" wrote: Show us condition No3 and someone will tell you how to count it Mike "DAN" wrote: I have a range of cells that have conditional formats with conditions 1, 2 and 3. Is there a way to count cells that display condition 3? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count cf cells displaying condition 3
Try
=COUNTIF($CI$3:$CI$51,B5) Mike "DAN" wrote: =ISNUMBER(MATCH(B5,$CI$3:$CI$51,0)) "Mike H" wrote: Show us condition No3 and someone will tell you how to count it Mike "DAN" wrote: I have a range of cells that have conditional formats with conditions 1, 2 and 3. Is there a way to count cells that display condition 3? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count cf cells displaying condition 3
Thank you. I'll work with it and see what happens.
"Mike H" wrote: Try =COUNTIF($CI$3:$CI$51,B5) Mike "DAN" wrote: =ISNUMBER(MATCH(B5,$CI$3:$CI$51,0)) "Mike H" wrote: Show us condition No3 and someone will tell you how to count it Mike "DAN" wrote: I have a range of cells that have conditional formats with conditions 1, 2 and 3. Is there a way to count cells that display condition 3? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells with condition | Excel Worksheet Functions | |||
| Count filtered cells meeting a condition | Excel Discussion (Misc queries) | |||
| Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
| how do I count pairs of cells when each matches a condition? | Excel Discussion (Misc queries) | |||
| how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
Linear Mode
