=Countif(range, criteria)

M

Miguel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
how to format cells -fill color 2
Tracked changes by multiple people modified to one 0
Student & Home? 1
Track Changes Settings 0
Macro Loop 0
Wrapping and Anchors 0
Add numbers if cell fill is a certain color; How To? 5

Top