Thread: Is it possible to combine countif and countcolor?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default Is it possible to combine countif and countcolor?
You did not tell us that someone has given you a UDF called 'colorindex' -
it is not part of native Excel
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Opal" wrote in message
...
Ah...

So:

=SUMPRODUCT((--(colorindex(B6:B34)=35))*(B6:B34="C"))


thank you!!

Reply With QuoteReply With Quote