counting cells by text color

[alberto]

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

 

[Peo Sjoblom]

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

 

[Bob Phillips]

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)

 

[MartinW]

And one more,

http://xldynamic.com/source/xld.ColourCounter.html#sorting

HTH
Martin

 

[alberto]

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

 

[alberto]

Thanks Peo,
i´ve already saw that link, but still don't know how to count specified
colored text (i.e. "david").
Alberto

 

[alberto]

And my office is 2003.

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