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)

MIKE

Thank you so very much for your quick and accurate reply. Solved the problem instantly. Very much appreciated.

Ask Your Question

Weekly Poll