Excel Formula for Inventory Management
2026-03-18
Current Stock Level
Track stock by subtracting sold from received. Received in B, Sold in C:
=SUM(B2:B100)-SUM(C2:C100)Reorder Alert
Flag items that need reordering when stock falls below a minimum (in D2):
=IF(E2<=D2, "REORDER", "OK")Inventory Valuation
Total value of inventory (quantity in E, unit cost in F):
=SUMPRODUCT(E2:E100, F2:F100)Average Days to Sell
Average number of days items stay in inventory:
=AVERAGE(G2:G100)Generate formulas instantly
Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.
Try FormulaWiz Free