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)

Here is Link to Sample Sheet Help File

https://docs.google.com/spreadsheet/ccc?key=0AvzHw18HODR0dDhoeWR6QWJBQ0twMVdLS3BXN0I4WEE

--------------------------------------------------------------------------

following is a solution to the problem