Need help with a formula in inventory

[zipper21]

I want to add number to A1 show total in A2 -A3 --
I want to be able to add new amounts to A1 and have A2 incress total.
Example
Recived On Hand Used
25 20 5
I recived 25 more pcs. same item my on hand should incress to 45 until
I use more.
Can anyone Help me

 

[Guest]

Hi zipper:

There are a numbre of good inventory templates available. Checkout:

http://office.microsoft.com/en-us/templates/TC060827171033.aspx

 

[Guest]

Hi zipper

Are you hoping to just be able to use those cells, or are you willing to
enter subsequent receipts into the rows below?
To do it as you state means using an accumulator-type of function which
means that you will have no history of what has been entered.

Andy.