Excel 2007 : Sum duplicate vlookup's

[derpotheman]

So I have data that looks like this

Item # Date Delivered Number Delivered
Item A 12/12/10 75
Item A 12/25/10 300
Item A 12/3/10 740
Item B ** **
Item B ** **

the stars just mean the same format. What I want to be able to do is use vlookup (on the item number) to give me the total delivered for the whole month (my sheet is for the month of december as you can see from my example data).

Is there a way I can do this?

[NBVC]

try Sumif:

=SUMIF(A:A,X1,C:C)

where column A contains Item #, and column C contains Quantities and X1 contains the Item # you want to add up. Note that this assumes, as you said, that all are for 1 month and you don't need to distinguish month also...

[derpotheman]

works great, thanks! i had like 6 nested if's which somewhat accomplished the task... but this is way easier

[1rcchopper]

Given the following table, how can I sum the fuel purchased in each individual state? I believe it would be a sumif formula, or hlookup, or a combination.

Fuel
Date State City Gallons
1/2/11 UT TREMONTON 186.548
1/3/11 CA BARSTOW 152.589
1/5/11 NV LAS VEGAS 178.500
1/7/11 UT SALT LAKE 139.780
1/8/11 NV CARSON
1/9/11 UT SALT LAKE 120.780


Totals
CA
NV
UT

[NBVC]

Welcome to the forum,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

[1rcchopper]

lets try this again. Given the table in the attached excel file, how can I sum all fuel purchased within each state? Thanks for your help.

[NBVC]

I mean you should start your own NEW thread instead of attaching onto somebody else's thread.