Inventory Spreadsheet formula

Wow, thanks guys, i'm going to give it a shot right now.

That spreadsheet works perfectly, thank you! I have to figure out how the formula works myself so I can use it in my spreadsheet, but yeah, that's exactly what I want it to do.