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