View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default 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