is this function correct?

H

Honza

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
 
R

Rick Rothstein

You can't do what you want, at least not directly, using only worksheet
formulas. If you numbers were colored as a result of a conditional format,
then you should be able to use the conditional formula itself in your own
formula... that is, check the condition that made the number red and react
to that. If your number is red because of a Cell Format (for example, red
because the number is negative), then again you can use the condition that
made the number red in your own formula. If the number is red for any other
reason, you will have to use VBA code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Sum Based on Cell Background Color 6
how to make excel simply count red x's? 4
=SUMPRODUCT revisited 7
Excel VBA - counting cells by colors and names to it in two different rows. 0
Array-friendly functions 1
how to make an IF function that has the same result as COUNTIF? 3
Sum.if criteria related to range of cells 3
Add-in function - language 3

Top