Hey guys, first post here, and have a question.

I am using Excel 2010

What i need is to find the following information from another workbook, this book is a "units received" sheet so there is alot of data based on each day something is received at the warehouse. Many columns for; part #, date, qty, PO etc..

1. Find the part #
2. Find the date range I specify (ex.10/1-10/31)
3. Sum the quantity received column for that date range

End result I want; Give me the total received in that month for that part #.

Is there a vlookup = sum(if) formula I can combine, or do I need something much more complex?

Thanks for the help!