Getting totals

rbsanders

New Member
Joined
Sep 23, 2003
Messages
10
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.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

Hard to understand...

What do you think about his?
Book1
ABCD
1SalesID,QtyOrdered,QtyShipped,QtyRemaining,
2120010190
3250010490
4310100
5110180
641001090
7150130
8210480
9120110
1041080
Sheet3
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,492
Messages
5,764,694
Members
425,231
Latest member
mramb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top