add range in one column, subtract range in another column

K

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
 
G

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
 
Top