Thread: count cf cells displaying condition 3
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
lee lee is offline
external usenet poster
  
Posts: 184
Default 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
Reply With QuoteReply With Quote