Inventory with stock in and out

The full inventory system distributors use: movements on one tab, balance calculated with SUMIFS, product name with VLOOKUP, a reorder alert and a chart by category.

Area: Retail. Level: Advanced.

Functions used: SUMIFS, IF, SUM, COUNTIF, SUMIF, VLOOKUP.

• Next project: Loan: amortization table
• All projects
• Lessons