# 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 appearIn the next column F5:F11 is a qty of boxes by type soE5 could read Blue, F5 could read 3. E6 could read Bent, F6 could read 9E7 could read Blue, F7 could read 1etc 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 etcThe 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?RegardsWayne

See More: I have an excel IF statement question

#1
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 8) 9) blue 4 ```In cell E9 enter the color blueIn cell F9 enter the formula:=SUMIF(E5:E7,E9,F5:F7)or if you don't want to use cell E9then just enter your color like:=SUMIF(E5:E7,"blue",F5:F7)MIKEhttp://www.skeptic.com/

Report •

#2
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 •

#3
November 16, 2010 at 10:19:30
 Glad I could help.MIKEhttp://www.skeptic.com/

Report •

Related Solutions