SUMIF for multiple column/sheet criteria

Hi,

Hoping someone can help.

I need to work out the qty of orders against an order number on a certain date.

Thing is I have 2 sheets with a HUGE amount of data on it, Book 2 has a list of order numbers and the date it was ordered, Book 3 has ALL orders with date and qty.

Is there a way to do the following:
From Book 2 column E, find these customer numbers from Book 3 column M - first criteria
From Book 2 column A, find these dates from Book 3 column F - second criteria
Find a resullt for how many qty ordered on that day with that customer number from Book 3 column P, this result should show in Book 2 column F

Hope that made sense!

Is the above possible? Find all orders placed on a certain date and present the qty ordered.

Thank you

Book 2.xlsBook 3.xls

Hello
If you were using Excel 2007 and above you could use the SUMIFS function. But as I believe you're using 2003 you can use the SUMPRODUCT function to return you Qty values based on the criteria of Date and Customer No. See attached files, with some added example data. If a customer has more than 1 order on a particular date the quantities will be added, unless you add further criteria. Not sure how this will perform on the HUGE amounts of data you mention but you can give it a go.

Hope this helps.