Compiling Inventory Data Living Across Multiple Columns
I am in the process of creating an inventory tracking sheet. Long story short, i built a form to keep track of inventory being taken out, and it offers 5 chances (so they drop into 5 different columns) to track any products counts taken out. I would like to be able to take those 5 numbers and compile them into one cell on my formula sheet. Any ideas how i would do that? The goal here is to keep a running count of live inventory, but i can only do this if i am able to bring all those numbers into the one cell! I've added a screenshot of 2 of the columns, and my formula sheet for reference. Any help on this would be so greatly appreciated. Its really stumping me!
Help Article Resources
Check out the Formula Handbook template!