Tuesday, November 8, 2016

yogi_Compute Row By Row And Column By Column Average Of Entries Submitted via Google Form

Google Spreadsheet   Post  #2082
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-08-2016
question by: BMosty:
How do I find the average of row sums when pulling data via Google Forms?
I am collecting data using Google Forms and retrieving responses in sheets.  Because each form response adds a row, I am having trouble with my formula.  

I need to find the total numerical score of each row and then find the average of these row totals.  I have established a separate sheet to run the formulas, but the combination of pulling data from a separate sheet, totaling across a row, and then averaging several totals is beyond my limited technical abilities.  

I have a sheet named "MP1 Responses."  I would like to find the total score of each row depending on the number of Google Form responses. Then, I need to find the average of row 2's sum, row 3's sum, row 4's sum, etc.  Then, I would like this average score to appear in B2 of my sheet named "Totals."

Based on my reading, it seems that I might need to use an array, but I am not sure how.  Any help would be appreciated.