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