Blog - Latest News

Below is an Inventory Tracking Table. The Number of Items Purchased Column contains the number of inventory items purchased (added to…

August 9, 2020/0 Comments/in /by developer

Below is an Inventory Tracking Table.
The “Number of Items Purchased” Column contains the number of inventory items purchased (added to balance).
The “Number of Items Sold” Column contains the number of inventory items sold (subtracted from balance).
In cell H13 formula that can calculate the inventory balance when a date is entered into the date column,
or show nothing when a date is not entered. Then copy the formula down the column through the range H13:H31.

0 replies

Want to join the discussion?
Feel free to contribute!