Stock availability — ordering = the rest?

Please tell me how to implement the inventory function
stock - order= residue
The presence and the order is known it is necessary to compare and take
a sample of the link https://docs.google.com/spreadsheets/d/1J11tSuJjTC...
5ccd75d7b53f3090310399.png
March 20th 20 at 11:45
2 answers
March 20th 20 at 11:47
do not quite understand the formula now will correct the issue, it is necessary to subtract from the arrival of the order ( each name selected from the list) in the balance sheet of stock (to simplify the problem, brought the total number in the order and the arrival of the goods) want to compare the position of the arrival of the goods (in blue) and subtract from it the order item ( yellow) - Nat.Stamm commented on March 20th 20 at 11:50
March 20th 20 at 11:49
this =SUMIF(E2:F10; B2; F2:I10)-SUMIF(H2:I10; B2; I2:I10) outputs the values like
but it is bound to the cell
3 sheet that I threw in there And the date in B the name. product without repeats in C what you need - jayde.Weber commented on March 20th 20 at 11:52
=SUMIF($E$2:$F$10; B2; $F$2:$I$10)-SUMIF($H$2:$I$10; B2; $I$2:$I$10) this is already better but is there any way to improve - Nat.Stamm commented on March 20th 20 at 11:55
you have in E7 and in H7 pen marker formula will no longer work - jayde.Weber commented on March 20th 20 at 11:58

Find more questions by tags Google Sheets