Inventory using excel
 

I am using an excel spredsheet to keep inventory of parts, I have:


A-item B-min level C-items used D-items recvd E-items on hand
1
2 abc 5 1 0
4
3 def 1 0 1
2

I am using formula : E2=B2-C2+D2
However while this work for first time, when i try and input new used item i
have to manually add new used to exiting used to get right total for items on
hand. I will be typing new data in c2 or d2 as used or recvd and would like
e2 to keep udated totals. Is there a formula or precedure for allowing this
to happen?--
LarryG

Inventory using excel
 

in cell E2 use this fromula =sum(b2-c2+d2)
then "items on hand" will auto update

regards DarkNight

"LarryG" wrote:

I am using an excel spredsheet to keep inventory of parts, I have:


A-item B-min level C-items used D-items recvd E-items on hand
1
2 abc 5 1 0
4
3 def 1 0 1
2

I am using formula : E2=B2-C2+D2
However while this work for first time, when i try and input new used item i
have to manually add new used to exiting used to get right total for items on
hand. I will be typing new data in c2 or d2 as used or recvd and would like
e2 to keep udated totals. Is there a formula or precedure for allowing this
to happen?--
LarryG

Inventory using excel
 

i need it to keep the total and then add or subtract when i enter new data.
ie- i enter 1 in c2, 0 in d2,then e2=4 then when i use another item i enter 2
in c2, 0 in d2, i want total to then be e2=2. Sum(b2-c2+d2) does exactly the
same as =b2-c2+d2.
--
LarryG


"DarkNight" wrote:

in cell E2 use this fromula =sum(b2-c2+d2)
then "items on hand" will auto update

regards DarkNight

"LarryG" wrote:

I am using an excel spredsheet to keep inventory of parts, I have:


A-item B-min level C-items used D-items recvd E-items on hand
1
2 abc 5 1 0
4
3 def 1 0 1
2

I am using formula : E2=B2-C2+D2
However while this work for first time, when i try and input new used item i
have to manually add new used to exiting used to get right total for items on
hand. I will be typing new data in c2 or d2 as used or recvd and would like
e2 to keep udated totals. Is there a formula or precedure for allowing this
to happen?--
LarryG