Forum Discussion
Need help measuring inventory levels
Hi good people. I need help calculating the Work In Progress (WIP) inventory for my work.
My Excel spreadsheet has three columns.
- Column A is the item’s unique identification code
- Column B is the time that the item entered the warehouse
- Column C is the time that the item left the warehouse
Is it possible to create an Excel formula in Column D that calculates the inventory level in the warehouse at the time of the item’s entry into the warehouse?
For example, if item 84363884U entered the store at 09:07:23, I would like to know the inventory levels in the warehouse at 09:07:23.
Here is a link to the Excel file for reference. Please and thank you.
In D2:
=COUNTIFS(B2:B1000, "<="&B2:B1000, C2:C1000, ">="&B2:B1000)
The formula result will spill to D2:D1000.
