Simple Inventory System without VBA

How to create a simple inventory system using formulas like SUMIFS, VLOOKUP and methods like data validation and conditional formatting.

A simple inventory system without VBA

[embeddoc url=”https://secureservercdn.net/160.153.138.177/z98.4d8.myftpupload.com/wp-content/uploads/2020/04/simple-inventory-system.xlsx” download=”all” viewer=”microsoft”]