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.

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.

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.