Running Total: Not Sure Which Function to Use

[thesuperman97]

Hello there! My name is Sean and I am trying to set up a function or formula to help keep a running total for stock levels. Example: Column I is the customer's order qty, column J is the running total, and column K is both the current stock on hand as well as the incoming shipments. Column N is the customer's requested delivery date which we reference for promising the next delivery. Currently I filter by part number, copy the data out to a new tab, and then use the following formulas to keep a running total: =sum(K1-I1) on the first line to establish the start of the runner, then I use =sum(J1-I2)+K2 and copy that formula all the way to the bottom. Now, when I enter the incoming shipments into column K, it helps determine when we will be short, and when we can expect to catch up.

My problem is, that I have 40+ parts that I need to filter, and I don't want to have to break each part out into its own tab. Is there a function or formula I can use (ie; Subtotal or Aggregate) in order to accomplish this on the main report without having to break each part out.

Any help would be appreciated.

If this belongs on a different thread, please send a link so I can copy and paste.

Thanks in advance for any help you all can provide!

Sean

[Pete_UK]

Take a look at the SUMIF and SUMIFS functions in XL Help (F1 key).

Hope this helps.

Pete