I am trying to use this statement in a cell:
=SUMPRODUCT(--(ColorIndex(A1:A3)=3),A1:A3), the cell returns #Name. The
only cells in use are A1 containing 24, A2 containing 16 and A3 containing
the above formula. Cell A1 background is colored red. What is wrong? I
would expect the sum to be 24.
--
skat


"Ron de Bruin" wrote:

See
http://www.mvps.org/dmcritchie/excel/colors.htm


--
Regards Ron De Bruin
http://www.rondebruin.nl



"skat" wrote in message ...
Where can I find the ColorIndex codes?
--
skat

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions