Thread: CONTIF DEPENDING ON TEXT/NUMBER COLOR
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fecozisk
 
Posts: n/a
Default CONTIF DEPENDING ON TEXT/NUMBER COLOR
the solution was under my nose!!!!!

=SUMPRODUCT(--(ColorIndex(A1:A5)=3)*(A1:A5="1f"))

THANKS A LOT!
now my problem is another... but for another topic!
Reply With QuoteReply With Quote