=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

Excel VBA 1
Excel Macro to automatically go to the right of the last colored cell 0
Selecting specific cells 1
How to add up all cells with no fill color 9
Excel VBA - Problem with Closing Print Preview 0
Formula for identify cell format - fill colors 3
cell pattern - color 2
How can I sum numbers that have a gray color-fill in cell? 1

Top