excel VBA cores...hold on, almost this

[lelebrasa]

Guys,
I did find a solution that is close to what I'm looking for but not the ideal.
i need to sum by color but PLEASE WAIT...
I have one column with numbers (no formats, no decimals, no colors etc) let say column "B".

If i need to sum the production by employee, so I will have colors in the columns "C", "D" and "E" for example.

so I need to look in the colors in the column c, d, e whatever and sum with number at column B...got it?

A B C D E F
10 Red yellow green n/a
15 yellow yellow n/a n/a
10 red red green n/a

p.s. doesn't need to say but will, where reads the color name will have the proper color LOL

return will be John (red) = 30 (10+10+10)
peter (yellow) = 40 (10+15+15)
Steve (green) = 20 (10+10)

 

[venkat1926]

why need coloring. use sumproduct with names or pivot table
post a small extract of data and explain