That definitely works if it's all on one page, but I'm actually referencing in from one workbook into another. I'm not quite sure if your method will work since the "master inventory list" is actually a database that isn't in the same workbook as the auto-populated list. Your method of putting a count on all non-blank values and then tracking it against those is a start, but since the database isn't "active" it won't allow for the way you want to do it.

Anyone else have any ideas how to reference it in, without having to modify the original master inventory list?