Does your machine have a ColorIndex function? Mine doesn't.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Honza" wrote:

Is this function correct? My excel doesnt understand it. Is it because my
excel is in french? Is that a problem? I dont know how to translate the
shortcuts for functions.

=sumproduct(--(colorindex(F89)(E89:H89)=3))

or

=sumproduct(--(colorindex(E89:H89)=colorindex(F89)))

What I want is to count just numbers that are for example red. And just dont
care about numbers that are black forexample.

Thank you for help.
Honza