is this function correct?
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
|