I'm using Excel 2007. It already contains a function called SumProduct but
it doesn't accept (--(colorindex(A1:A2)=3),A1:A3). Could you please give me
the code that I have to enter in a macro for colorindex? How can I use the
Excel 2007 SumProduct function to selectively sum only the cells with a red
background?
skat


"Peo Sjoblom" wrote:

You have to install the colorindex, it a Use Defined Function (UDF)

http://www.mvps.org/dmcritchie/excel/install.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"skat" wrote in message
...
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