Products | Colour | Number of Smooth Doors = 25002770 | Number of Blue Doors = 46004100 | Number of Red Doors = 30003150 |
2x30003150, 2xMRC2562, PAD2500, | RED | 7 | 4 | 6 |
4x46004100, 2xmrc | BLUE | |||
4x30003150, 4xmrc, PAD250 | RED | |||
5x25002770 | Cream | |||
2x25002700 | Cream |
<tbody>
</tbody>
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.