View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Opal Opal is offline
external usenet poster
 
Posts: 59
Default Is it possible to combine countif and countcolor?

I have a range of cells and I need to count how many
have a blue background and a cell value of "C" and how
many have a green background and a cell value of "C"

I can count all the cells in the range that are blue or
green and I can count all the cells that contain the
value of "C", but how can I count the combined
criteria?

I'm thinking I just need some algebraic help... :-S