Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif with a Range of criteria | Excel Worksheet Functions | |||
countif, range and criteria | Excel Discussion (Misc queries) | |||
Countif with date range criteria | Excel Worksheet Functions | |||
CountIf for a range with multiple criteria | Excel Discussion (Misc queries) | |||
SUM(COUNTIF(range,NOT Criteria)) | Excel Worksheet Functions |