Google Spreadsheet Post #946
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.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
--------------------------------------------------------------------------
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)
--------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment