You can't use anything built in unless you have 2007,

http://www.cpearson.com/excel/colors.htm

have functions that you can use after creating them as UDFs

if you have 2007 you can't sum/count by colour but you can filter by colour
and the sum the visible cells using SUBTOTAL

--
Regards,

Peo Sjoblom


"alberto" wrote in message
...
Hi,
What formula can i use to get the total of cells by counting text with
diferent color?
ex:
NAMES
david
joe
richard

David and Richard are writen in black and Joe writen in red; so my
calculation shoud be = to 2, or for other hand = to 1.
Any help?
Thanks.
Alberto