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
etc etcI 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?
Regards
Wayne
I believe what your looking for is a =SUMIF() function. If your data looks like this:
E F 5) blue 3 6) bent 5 7) blue 1 8) 9) blue 4In cell E9 enter the color blue
In cell F9 enter the formula:=SUMIF(E5:E7,E9,F5:F7)
or if you don't want to use cell E9
then just enter your color like:=SUMIF(E5:E7,"blue",F5:F7)
Thank you so very much for your quick and accurate reply. Solved the problem instantly. Very much appreciated.