| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=Countif(range, criteria)
check out this link...
http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH... Jim Thomlinson "Miguel" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=Countif(range, criteria)
hi
you may need an UDF for that. see this site for details... http://cpearson.com/excel/colors.aspx regards FSt1 "Miguel" wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
