Question about If function

Hello, and Nice to meet you.
I am trying to do subtract calculation and I am kinda stock...
I have attached my excel sheet so kindly refer.
At Master Sheet F2, I am trying subtract/add number from C2 with both IN sheet and Out Sheet (Quantity In or Quantity Out)
So my F2 (After Transaction Quantity calculation would be something like
If (!IN, A2 field contains HotdogBox1), (!MasterC2 + !InD2)
After Transaction Quality at Master sheet should be (100 + 20), 120

If (!Out, A2 field contains HotdogBox2), (!MasterC2 + !OutD2)
After Transaction Quality at Master sheet should be (100 - 20), 80.

Hope I explained what i am trying to do.

Kindly help me out!

Try this in F2:

=C2+SUMIF(In!A:A,A2,In!D:D)-SUMIF(Out!A:A,A2,Out!D:D)