| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Defining a number in a cell by text then subtracting it by the tex
Ok, this might get confusing and considering I have no training in this, this
ought to be good. I am doing an inventory workbook. Say I have 4 lipsticks in stock and its Part number is 10-6161. Everytime I enter the Part Number (10-6161) in a column on Sheet B, I want it to subtract from the number I have in stock on Sheet A. Site Layout: Sheet A Cell A1 Part Number 10-6161 Cell D1 In Stock Number 4 Sheet B Column A Part Number 10-6161 Subtract Sheet B Column A from Sheet A Cell D1 I hope someone is able to help me. This is confusing. |
|
#2
|
|||
|
|||
|
Hi
e.g. in F1 on sheet 1 enter =D1-SUMIF('sheet2'!A:A,A1,'sheet2'!B:B) to get the current stock level in cell F1 "Crowraine" wrote: Ok, this might get confusing and considering I have no training in this, this ought to be good. I am doing an inventory workbook. Say I have 4 lipsticks in stock and its Part number is 10-6161. Everytime I enter the Part Number (10-6161) in a column on Sheet B, I want it to subtract from the number I have in stock on Sheet A. Site Layout: Sheet A Cell A1 Part Number 10-6161 Cell D1 In Stock Number 4 Sheet B Column A Part Number 10-6161 Subtract Sheet B Column A from Sheet A Cell D1 I hope someone is able to help me. This is confusing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| how to hyperlink text to a cell | New Users to Excel | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Hybrid Mode
