View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Honza Honza is offline
external usenet poster
 
Posts: 1
Default 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