Getting totals

[rbsanders]

I have a spreadsheet that keeps track of my shipments. It includes columns for SalesID, QtyOrdered, QtyShipped, QtyRemaining, DueDate, ShipDate, and DaysLate. Some of these shipments are part of a large order that are promised and shipped at various dates during the year. I would like to be able to keep track, in a separate sheet within the worksheet, the original total quantity of the SalesID, less all the shipments for that SalesID to show me how many are still remaining to ship for the total order. For example, SalesID #0012345 had a total order quantity of 100,000 pieces. We promised to ship 10,000 on the first of each month until the order is complete. I want the shipping clerk to be able to enter the shipments in order as they are shipped in the original spreadsheet. Since I have many SalesID numbers, each SalesID could have many shipments spread throughout the spreadsheet. I've tried to use DSUM but it seems that I am limited in the criteria area. I couldn't figure out how to do it with a lookup. Any suggestions?
Thanks.

 

[fairwinds]

Hi,

Hard to understand...

What do you think about his?

Book1
	A	B	C	D
1	SalesID,	QtyOrdered,	QtyShipped,	QtyRemaining,
2	1	200	10	190
3	2	500	10	490
4	3	10	10	0
5	1		10	180
6	4	100	10	90
7	1		50	130
8	2		10	480
9	1		20	110
10	4		10	80
Sheet3