add range in one column, subtract range in another column

[kasey]

trying to do simple total for in/out of inventory. would like to add total
received vs total used, separate column for received, used. thx

 

[Gary''s Student]

In A1 put the initial inventory

In A2 enter:
=A1+B2-C2 and copy down

enter received counts in column B
enter used counts in column C