Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif colored numbers
I am looking to count a certain colored numbers in a column.
Example: All the Blue numbers, then all the Red numbers. I looked over "Color Functions In Excel" and that didn't really seem to help. I tried =COUNTCOLOR and it had a #NAME type error. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif colored numbers
See http://www.xldynamic.com/source/xld.ColourCounter.html
You have to inset your counting function. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mark" wrote in message ... I am looking to count a certain colored numbers in a column. Example: All the Blue numbers, then all the Red numbers. I looked over "Color Functions In Excel" and that didn't really seem to help. I tried =COUNTCOLOR and it had a #NAME type error. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif colored numbers
Take a look at this link:
http://www.cpearson.com/excel/colors.aspx which shows how to count and sum by colour. Hope this helps. Pete On May 22, 6:58*am, Mark wrote: I am looking to count a certain colored numbers in a column. Example: All the Blue numbers, then all the Red numbers. I looked over "Color Functions In Excel" and that didn't really seem to help. I tried =COUNTCOLOR and it had a #NAME type error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colored numbers | Excel Discussion (Misc queries) | |||
Converting colored cells to numbers- is there a formula? | Excel Worksheet Functions | |||
How do i formulate to add certain colored numbers? | Excel Discussion (Misc queries) | |||
COUNTIF for range of numbers | Excel Discussion (Misc queries) | |||
Countif for numbers between x and y | Excel Worksheet Functions |