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.

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.