| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| EXCEL Sum column based on time range in different column? | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
Linear Mode
