Count values in a column

[Immortal2014]

Hello guys
i need your help with a little problem.
I have a column (I), in all rows i have nicknames and some of them are with red font color. Can i count how many nicknames are with red font color?
Example: "Nick" 3 times with red font color
"George" 15 times with red font color etc.
Thanks in advance.

[mcmahobt]

Although Excel has no built in function to count cells based on text color, this may help you accomplish what you need:

http://www.extendoffice.com/document...ont-color.html

Hope this helps!

[Immortal2014]

mcmahobt thank you very much for your quick answer but i need to count, not sum. Also i need count any cells of column I who listing the nickname "Nick" only with red font color. Thanks again!

[mcmahobt]

That website defines two methods...counting OR summing based on text color, not just summing.

[Immortal2014]

Ok i found a way and i'm ok with it.