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 https://docs.google.com/spreadsheets/d/1gGFG8NKqIbSKHP-hkrKyJkd7k6gjGTyA/edit?usp=sharing&ouid=113577427765249841163&rtpof=true&sd=true for reference. Please and thank you.
1 Reply
In D2:
=COUNTIFS(B2:B1000, "<="&B2:B1000, C2:C1000, ">="&B2:B1000)
The formula result will spill to D2:D1000.
