Automated inventory counter via tables

[nanman357]

Looking to create an automated inventory counter using tables.

The idea is:

There is a beginning inventory state. There are sales and items that are 'given-out' (not charged for).
The inventory counter adds up all the sold and given-out items, removes them from the beginning state, giving the result of current inventory.

What I can't manage to do is have the counter "know" that the cell in 'sold' or 'given-out' is to be removed from the beginning inventory by the NAME of the product.

I need something that I can update constantly in the sold and given-out tables because I will be adding to them regularly.

Thanks for any tips, the file is in the attachment.

P.S. Dont laugh at the procuts, you know what they are..

[Pauleyb]

Not sure where you want to track your inventory. Specifically, how do you add new inventory? I'll provide a possible solution, but I'm thinking you will need to adjust it, so hopefully it helps you get started.

In G3:
=SUMIF(Table1[Produkt],[@Produkt],Table1[Sztuki])-SUMIF(Table4[Produkt],[@Produkt],Table4[Sztuki])-SUMIF(Table46[Produkt],[@Produkt],Table46[Sztuki])

That should then autopopulate the rest of the table.

[nanman357]

Thanks Pauleyb, that was exactly what I needed! Problem solved.