S
snoopy
Maybe someone can help me. I have been trying to work on this for some
time and I can't figure it out. I want to create an inventory list
which tracks the number of items in inventory, items sold, and a total
of items sold. For instance,
I want my list to have the following headings (or something similar) as
shown below in cells C2:E2.
Inventory Quantity Sold Total Quantity Sold
6
In cells C3:E3 I would like to enter the starting inventory (say 6
chairs). Then everytime a chair sells I would like to be able to enter
in cell D3 the number sold and have it total it in cell E3 under the
heading Total Quantity sold. I guess the tough part is to have cell D3
act independently so everytime another chair sells I can input it under
cell D3 and in cell E3 it will remember all previous chairs sold as
well. Can anyone help me with this or is this formula not possible?
time and I can't figure it out. I want to create an inventory list
which tracks the number of items in inventory, items sold, and a total
of items sold. For instance,
I want my list to have the following headings (or something similar) as
shown below in cells C2:E2.
Inventory Quantity Sold Total Quantity Sold
6
In cells C3:E3 I would like to enter the starting inventory (say 6
chairs). Then everytime a chair sells I would like to be able to enter
in cell D3 the number sold and have it total it in cell E3 under the
heading Total Quantity sold. I guess the tough part is to have cell D3
act independently so everytime another chair sells I can input it under
cell D3 and in cell E3 it will remember all previous chairs sold as
well. Can anyone help me with this or is this formula not possible?