I have an excel IF statement question

November 16, 2010 at 07:57:33
Specs: Windows XP
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 etc

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?

See More: I have an excel IF statement question

Report •

November 16, 2010 at 08:13:00
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
9) blue	    4

In cell E9 enter the color blue
In cell F9 enter the formula:


or if you don't want to use cell E9
then just enter your color like:




Report •

November 16, 2010 at 09:50:41
Thank you so very much for your quick and accurate reply. Solved the problem instantly. Very much appreciated.

Report •

November 16, 2010 at 10:19:30
Glad I could help.



Report •

Related Solutions

Ask Question