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    Dec 30, 2012
user Nick Wohlfarth said:(!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