SUMIF with color criteria

Hi All,

I’m in trouble creating a macro that will sum products based on color criteria. I attached a file how should the report look like. The first sheet has to contain production quantities and all cells have to be colored to assigned products, now start the calculation problems - above the table a some kind of “sumif” formula to get the total planned quantities is needed. You know, this takes time to fill in but still a summary report is needed where I need to put together the qty and indicate the product in one cell.
It takes me a whole day to fill in this report…
Can someone help with a macro – miracle that can do?

Hope, You can help
Alex.