Sunday, November 16, 2014

yogi_Summarize Stats (Specified Fields) For Projects From 'Form Responses (Data)' Sheet

                Google Spreadsheet   Post  #1834
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-16-2014
post by JSeigleBuilt:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/BQyTTnKzJQ0)
Help with summarizing form responses in another sheet
Hi All,
I have a form that returns progress reports from the crew of my contracting company.  I would like to create a separate sheet that summarizes this data based on each particular Project.  The information (and some example data) I would like to see is contained in the "Summary" sheet.  The raw data is in the "Data" sheet.


Here's a link:


Any help would be greatly appreciated.

Thanks,
Kaleb
------------------------------------------------------------------------------------------------------------------------------------------------