ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   add range in one column, subtract range in another column (https://www.excelbanter.com/excel-worksheet-functions/208100-add-range-one-column-subtract-range-another-column.html)

Kasey

add range in one column, subtract range in another column
 
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

add range in one column, subtract range in another column
 
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
--
Gary''s Student - gsnu200810


"kasey" wrote:

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



All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com