Cell values in same column summed to different cells based on color

[slopez94]

Hello, Everyone.

I am needed to sum the numerical value of cells in the same column based on the data source cell color. For example, in the area below in the red square any cell in blue should be summed to K3 for Production Labor, any cell in green should be summed to K7 for Paint Labor.

How could I insert a sum formula to K3 & K7 to include the cell range in the red square while only summing the correct color cells?

 

[dermie_72]

what qualifies the color of the cell?

 

[slopez94]

what qualifies the color of the

The green or blue cell is just a manual color fill to identify different resources. They don't necessary need to be different colors, I just need to find a sum if formula and find a way to have the different row values in that cell range (red squared) get summed to the sum cells up up if they are paint or production.

 

[dermie_72]

You could use a sumifs of the column you want, and include the work area as part of the criteria.