Forum Discussion
Chew_Tong_BryanV
Sep 03, 2024Copper Contributor
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 ...
HansVogelaar
Sep 03, 2024MVP
In D2:
=COUNTIFS(B2:B1000, "<="&B2:B1000, C2:C1000, ">="&B2:B1000)
The formula result will spill to D2:D1000.