Need help with a formula in inventory
 

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


--
zipper21
------------------------------------------------------------------------
zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025
View this thread: http://www.excelforum.com/showthread...hreadid=528481

Need help with a formula in inventory
 

Hi zipper:

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

http://office.microsoft.com/en-us/te...827171033.aspx
--
Gary's Student


"zipper21" wrote:


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


--
zipper21
------------------------------------------------------------------------
zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025
View this thread: http://www.excelforum.com/showthread...hreadid=528481

Need help with a formula in inventory
 

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.

"zipper21" wrote in
message ...

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


--
zipper21
------------------------------------------------------------------------
zipper21's Profile:
http://www.excelforum.com/member.php...o&userid=33025
View this thread: http://www.excelforum.com/showthread...hreadid=528481