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

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History