Forum Thread: How to Update Inventory in Excel

I would like to know if there is a way to deduct from the totals of several cells by entering a total in one cell?

Example: If I enter a 1 in the cell that says "Bike", it will deduct 1 from the "seat" cell , 2 from the "pedals" cell, 2 from the "wheels" cell, etc.