Sum if?

[james2]

Hi, I'm trying to have excel 2007 sum a value in one column if another column matches the value.

Here's something similar to what I have:

A | B | C
Item | Order # | Cost
Widget | 046 | $50.00 |
Thingamagig | 047 | $100.00
Dohickey | 046 | $70.00

I'll have multiple items with the same order number, and I want excel to give me a total of the cost column for all items that are from a certain order i.e.

Order 046 Total: $120.00

[jeffreybrown]

Take a look at sumproduct

http://www.xtremevbtalk.com/showthre...37#post1285037

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

[daddylonglegs]

If it's just by order number then SUMIF should be sufficient. If you list specific order numbers in E2 down then try this formula in F2 copied down to get a total for each

=SUMIF(B:B,E2,C:C)

[ChemistB]

What you're looking for is what you called it "SumIF"
=SUMIF($B$2:$B$500,D1,$C$2:$C$500) where D1 contains the order # you want to sum. Make sense?