Thread: Count a Range, but only those cells with Black font Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
  
Posts: 454
Default Count a Range, but only those cells with Black font Q
I have the formula below that counts the number of instances of the
value held in A43 that appears in the range D9:AG35, but how could I
also include the qualifier thatonly count the number of these values
that are in Black font? Is this possible?

=COUNTIF($D$9:$AG$35,A43)
Reply With QuoteReply With Quote