Showing posts with label Cloud Computing ... question by Wardssmith. Show all posts
Showing posts with label Cloud Computing ... question by Wardssmith. Show all posts

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
-----------------------------------------------------------------------------------------------------