Dear all
Im preparing a material orden template at work.
Materials can go either on floors or walls.


Next to each option (floor or wall) I've created a drop down list with all available colours.
So you could have wall 1 in colour 1, wall 2 in colour 2, wall 3 in colour 3, and floor 1 in colour 2, floor 2 in colour 1 and floor 3 in colour 3

What i would like to do is, matching the quantities of each colour. In this case, i would need to sum up for colour 1 walls 1 and floor 2, for colour 2 wall 2 and floor 2 and for colour 3 wall 3 and floor 3.

I tried doing VLOOKUP but it's not what i need.
I need a function that can recognise the parameters in the drop down list, bulk them together and bring up the sum of quantities signed to each colour.

If you see the xls file, for example for the colour CEMENTO, I have 1 meter, 2 meters and 9 meters.
I need a formula that can identify the colour, and bring back the sum of 1 +2 +9

THANKS

Attached Files

Material order TOPCRET-2.xlsx (39.9 KB, 10 views)