|I have from E5:E11 and F5:F11 data that is being picked up from an adjoining worksheet.|
In those cells E5:E11 the product words Blue, Fesc, Bfr, BSC, Bent could appear
In the next column F5:F11 is a qty of boxes by type so
E5 could read Blue, F5 could read 3.
E6 could read Bent, F6 could read 9
E7 could read Blue, F7 could read 1
I would like to do an if statement in a set of cells that tells me in those 7 rows how many boxes of each product do I have..
So one column would say Blue with the total number of boxes of blue under it etc
The worksheet where the data for E5:E11 and F5:11 change everyday.
I'm sure this is probably easy for some of you but I'm stumped. Can anyone help me please?