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

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

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

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

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

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