Creating an Inventory that updates as transactions are entered

Hello,

I need a bit of guidance as I've been stuck on this problem regarding how to have an up-to-date table that shows the current inventory remaining.

I want to see the a LIVE count of how many clothing I have remaining and what size they are.

In the first spreadsheet, I have a table of what kind of clothing I have and the Size I have.
In the second spreadsheet, I have a list of transactions with the following fields, Date, Name, Clothes, Size, and Price.
As time goes on, whenever a sale occur, a new entry will be made with the above fields mentioned.

What is the best approach to have a table similar to the one the first spreadsheet where the numbers can automatically adjust based on a transaction that occurred?

An example of what I mean is let's say I have 33 Small Black Hoodies, and I just added an entry in the transaction spreadsheet where John purchases 1 Small Black hoodie.
How can the table automatically adjust to accommodate the sale of the Small Black Hoodie?

Thanks in advance

Originally Posted by TMS

Please see the attached worked example.

Thanks a lot man! This is what I needed and now I learned how to use the COUNTIFS function because of you. really appreciate it