I am trying to create a formula however wonder if it is too complicated. I am trying to use it to keep a running total of inventory. I have a sheet that will contain the 'Quantity Available' and another sheet that has the parts. The formula I am trying to create is to pick up the count from the other sheet that has a running total of Quantity In + Quantity Out which gives the total amount available however I am trying to get it to pick up when the Product Type only says 1/4" O-Rings for example.
I have tried doing the formula a couple of different ways and it isn't working.
Need the formula to show something along the lines of =SUMIFS(Quantity In+Quantity Out, Product Type = 1/4" O-Rings). This would mean the quantity available is only relevant to the O-Rings of that size however it has a running balance so as more O-Rings come in and out the quantity available in the other sheet will always continue to update.
For reference I have included an example. Sheet 1 would contain the running balance and Sheet 2 would contain the information.
E.g I need to be about to get the quantity available in sheet 1 to show 2 (3 in and 1 out for only the 1/4" O-Rings).
Would love to know if this is even possible! If so, please send through ideas as to how the formula would make it work.
Help Article Resources
Check out the Formula Handbook template!