Google Sheets Inventory Tracking Formula Guide
2026-03-18
Running Stock Balance
Calculate current stock from received and shipped columns:
=B2+SUMIF(D$2:D2, A2, E$2:E2)-SUMIF(D$2:D2, A2, F$2:F2)Low Stock Alert
Highlight items below minimum stock level (minimum in column G):
=IF(H2<G2, "LOW STOCK - REORDER", "OK")Total Inventory Value
Calculate total value of all inventory (quantity in H, cost in I):
=SUMPRODUCT(H2:H100, I2:I100)Days of Stock Remaining
Estimate days until stockout based on daily sales rate in J:
=IFERROR(H2/J2, "N/A")Generate formulas instantly
Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.
Try FormulaWiz Free