Substract / add ONLY after checking several colums if its the same

[Ignore]

I'm currently making an excel file for someone. But I'm quite stuck.
Here's the problem.

Size	Quality	order supplier	order customer	Stock
5X5	High	200	150	50
5X5	High	50	50	50
6X9	Low	100	25	75
5X5	High	0	50	0

<tbody>
</tbody>

I can't find the formula for stock. It MUST check size and quality before being able to substract / add. The column Stock must know wh ere to substract. Only if quality and size is the same.

 

[Ignore]

I tested it out. It works great, only if I add new rows, the cell says: doesn't correspondent to the column formula.
So it doesn't update automatically

 

[Ignore]

Managed to let it work :D Thanks
Now I added some a tabel and some colors. Red color is negative. I want to order them by colors red for example.
The red cells won't come up

 

[Canapone]

Hi,

formulas are reading the progression of your data: relative references in the formulas do the trick.

You cannot sort the formula results without changing the results (hope it makes sense).

Maybe filters and conditional formats could help your analysis

Regards

 

[Ignore]

Everything works fine! thank you for your time