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

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