CONT.IF and color condition?

[Fecozisk]

Here I am again!
Is it possible to use CONTIF not just for numbers, but also for colors?
For example, I´d like to use contif to cont how many "red 6" in a determined
interval. Is it possible?
thanks

 

[Tom Ogilvy]

Not with built in functions, but see Bob Phillip's page no this:

http://www.xldynamic.com/source/xld.ColourCounter.html

 

[Fecozisk]

could you help me little more with this?

i visited the page you showed me but i couldnt make everything work...
ater copying and paste the codes in visual basic I isertet:
=SUMPRODUCT(--(ColorIndex(A1:A100)=3))
and this worked fine.

but when I inserted:
=SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3))
that should counts all cells with red text within the range A1:A100 ir didnt
work... It focused a problem on A100,TRUE

Nothing is working when using TRUE!

ps: My excel is in PORTUGUESE, so i changed SUMPRODUCT to SOMARPRODUTO,
which is the relative... Ive tried changing TRUE to its relative in
portuguese but it didnt help...

Any suggestions?
Thanks