calculate a running total from updated cells

Paul Johnson

I have a spreadsheet which tracks the order process .

A simple dropdown list qualifies a cell as either "quoted" or " PO received".

Once that cell has changed to "PO received"  I'd like to deduct the qty for that order from "stock in warehouse" so That I can see at a glance how much available stock I have.

Is there a formula I can use that checks a cell in a row by its identifier and subtracts its adjacent cell " QTY on order " from my " stock in warehouse"  Any Ideas?

 

Greg Gates

You sure can! This is what the "SUMIF" formula is for. I imagine your formula would look something like this:

 

=[Warhouse Stock]1 - SUMIF([PO Status]:[PO Status], "PO Received", [QTY On Order]:[QTY On Order])

 

I hope that helps! I'm just guessing at your column names, so let me know if you have any questions or if it didn't solve your problem.

Cadsolutions - Paul Johnson

Hi Gregg, that's perfect , worked a treat. Thanks for the prompt reply