Rather than summing by color, sum by the condition that creates the color.
Since green means 50000, your formula is:
=SUMIF(B7:V7,"50000")

To sum a group of cells between 50000 and 10000, formula is:
=SUMIF(B7:V7,"10000)-SUMIF(B7:V7,"=50000")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"duketter" wrote:

Excel 2007 - I am trying to sum the numbers in a row (D2:V2) and if the cells
are highlighted in green or orange I want the numbers added. I am using the
sumcolor module. It works if I manually color/highlight the cell. However I
have the cell highlighted based on conditional formatting (for example: green
= numbers over 50,000) then the sumcolor function will not work. It won't
pick up the cells that are highlighted by conditional formatting. Here is my
formula:
=sumcolor($A$2,B7:V7)+sumcolor($A$3,B7:V7)

A2 (green) and A3 (orange) are the blank colored cells for reference. B7:V7
is the data I want to analyze and sum.

Can this be done with conditional formatting on?