I have basic knowledge of excel and have been reading myself nuts with
different functions. I am trying to put together a spreadsheet that will give
me live Inventory availability. I've tried all kinds of functions in all the
totals row to get the totals in "Available Inventory" and "Total ON
HOLD". Once I think I have it figured out then I won't have product in the
Hold column and it throws off my total in "Total ON HOLD". Thank you in
advance for any help. This is what I want it to look like.

Available Inventory 3,900
Total ON HOLD 100

Date HOLD Shipped Inventory Produced
3/1 Beginning Inventory 5,000
3/3 Shipped Product 2,000
3/4 Produced 1,000
3/5 Sold 100
Totals 100 2,000 5,000 1,000