count cf cells displaying condition 3

[DAN]

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

 

[Lee]

Use the count if function

=Countif(range,"3")

 

[Mike H]

Show us condition No3 and someone will tell you how to count it

Mike

 

[DAN]

=ISNUMBER(MATCH(B5,$CI$3:$CI$51,0))

Show us condition No3 and someone will tell you how to count it

Mike

 

[Mike H]

Try

=COUNTIF($CI$3:$CI$51,B5)

Mike

=ISNUMBER(MATCH(B5,$CI$3:$CI$51,0))

 

[DAN]

Thank you. I'll work with it and see what happens.