formula to subtract from inventory total
 

Hello,

I would like to set up a spreadsheet where I have a call with a total number
of paqs that I have in inventory. I have a column called Units where I enter
the units a customer orders. I would like to have excel subtract the number
of units in the Units column from the cell where I have the total number of
paqs. For instance, I have a cell that says I have 100 paqs in stock. Each
time I sell a paq to a customer I add their name and the number of units sold
Customer Units Date
Name 1 02/10/10
Name 3 02/10/10
How do I get excel to subtract the number of units from the cell that
contains the total number of units.

Thanks very much for your help.

Best regards

Dee

formula to subtract from inventory total
 

D1: holds 100 pags

C1: =D1-SUM(B:B)


"Dee" wrote:

Hello,

I would like to set up a spreadsheet where I have a call with a total number
of paqs that I have in inventory. I have a column called Units where I enter
the units a customer orders. I would like to have excel subtract the number
of units in the Units column from the cell where I have the total number of
paqs. For instance, I have a cell that says I have 100 paqs in stock. Each
time I sell a paq to a customer I add their name and the number of units sold
Customer Units Date
Name 1 02/10/10
Name 3 02/10/10
How do I get excel to subtract the number of units from the cell that
contains the total number of units.

Thanks very much for your help.

Best regards

Dee