CONT.IF and color condition?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top