View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MIguel MIguel is offline
external usenet poster
 
Posts: 33
Default =Countif(range, criteria)

When I use this formula I want it got a huge range of cells but I have
particular cells that have a Fill Color in them. Now on the criteria I want
it to count the cells that have a fill color in them?

I've tried using "Fill Color(Color I'm using)" after the comma in formula
but I still get a 0 count when I. I've also tried just doing =countif(range,
then just the color) but it doesnt seem to count the cells that have a fill
color.

Could anyone help me with this?