add range in one column, subtract range in another column

  • Thread starter Thread starter kasey
  • Start date Start date
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
 
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
 
Back
Top