With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, December 30, 2012
yogi_In Summay Sheet SumUp Values For Entities in Row 1 Of Sheets In Column A
Google Spreadsheet Post #946
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 30, 2012 user Nick Wohlfarth said:(http://productforums.google.com/forum/?zx=y1lexgi8u6aw#!mydiscussions/docs/FEU4kEg-318) Enter a Sheet Name into a Function from a Text Cell
Using this Function on Summary Sheet =SUMIF('agh north'!A:A;"NESE";'agh north'!B:B)
The Function Searches Column A for NESE then Summarize Data from B on Summary Sheet.
The Sheetnames are n Column A of Summary Sheet
Need a Function to Enter SheetName pull name from Column A into Formula.
This Has Been Successful Where A3 is Sheetname > =INDIRECT("'" & A3 & "'!" & C3)