I have inventory for two different parts being built on two different spreadsheets. The newer part has many of the same components as the older part, and a few parts exclusive to it. I need to keep a total quantity on hand of all of the components in my shop, but I don't know how to get that count to automatically generate from the number of parts that we ship out.
Solved by E. H. in 27 mins