Sunday, July 26, 2015

yogi_Compute Remaining Inventory Considering Items Sold As Delineated In Sheets A and B

Google Spreadsheet   Post  #1975
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-26-2015
post by  Wardssmith:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/vh18-76CkEI
Is there a way to get a sum of all A2 cells in all sheets using a wildcard of sorts?
Is there a way to get a sum of all A2 cells in all sheets using a wildcard of sorts? 
May be more involved than originally suggested...In sheet 2 (Inventory) I would like to keep a running total of sold units based on the reports of newly generated sheets A  and B.

https://docs.google.com/spreadsheets/d/16VSQpS9dTJMoXXU6TIQErc8z91N1vRLDMlJGAAJnrRo/edit?usp=sharing
-----------------------------------------------------------------------------------------------------