Defining a number in a cell by text then subtracting it by the tex

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I subtract with text valued number instead of an actual num 15
Excel Subtracting multiple columns from another column 3
Add/Subtract columns from tab to tab in same file 3
cell w/ drop down then reference 5
Conditional Formatting Issues 1
How to count the maximum number flanked by zeros 9
Vlookup in multiple sheets 2
Reducing numbers by one in defined areas over several sheets 12

Back
Top