Calculating Inventory at the End of the Month

[mitylene]

I have a workbook that is for Inventory and a separate workbook that has all the Sales Orders in one sheet and Purchase Orders in the other.

I am trying to figure out 3 calculations. Total quantity from all the Sales Orders at the End of the Month (by Item #), total quantity from all the purchase orders at the End of the Month (by Item #), and Month Close Inventory (Inventory - All Sales Orders + All Purchase Orders by End of the Month).

I figured out how to calculate the End of Month Date using Today's Date. But I don't know how to:
1) Search by Item # all the Sales Orders
2) if "Ship Status" Column B is N
3) if "Del Due Dt" is on/before "End of Month Date"
4) then add ALL "Qty Ordered" together
5) Output to inventory workbook

Then do the same for Purchase Orders.

Any help would be much appreciated!
Thanks,
-M

[royUK]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Moved to Excel Functions