Thanks Bob,
but how can i use =SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3)) whit a text
condition? (i.e. "david")

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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