Hi,
Let's say you have in column A received, in column B Pick up, in column C
total
Let's assume that in cell C1 you have the initial inventory = 100, in cell
C2 enter

=C1+A2-B2 and copy all the way down

"Danlet" wrote:

hello,

I want to do an inventory. I want to have two cells, one to put quantity
recieved and it to appear and add whats already in the second colum.
Example, in quantity total I have 100 items. I want to beable to put 50 in
quantity received and have quantity total change to 150. Thank You