|
ColorIndex
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 |
ColorIndex
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 |
ColorIndex
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 |
ColorIndex
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 |
ColorIndex
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 |
ColorIndex
In 2007 you can actually apply autofilter using color, then use subtotal to
sum =SUBTOTAL(9,A2:A50) http://www.cpearson.com/excel/colors.htm look for "Summing the values of cells with a specific color" copy from Function SumByColor until and including End Function however since 2007 has that built in I would suggest the filter way -- 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'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 |
| All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com