|Products||Colour||Number of Smooth Doors = 25002770||Number of Blue Doors = 46004100||Number of Red Doors = 30003150|
|2x30003150, 2xMRC2562, PAD2500,||RED||7||4||6|
|4x30003150, 4xmrc, PAD250||RED|
Hello, just need a basic (hopefully formula which would work out the above)]
In the product column there could be a whole range of products - however we only care about 30003150, 46004100, 25002770.
We need to find the amount of doors found by 2x ( with these products only ) - for exmaple of any amount found 1x,2x,3x,4x,5x,6x,7x,8x
Totalling in column C/D/E (row 2 is fine)
Any ideas? ISNUMBER/LEN/ I tried so much I just can't work it out.