Friday, December 9, 2011

yogi_Compute Average Of Numbers By Rows In Multiple Columns -- Test Grades

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user worldlylime36 said:
average multiple rows to get multiple values
I am fairly new to working with formulas and am trying to create a grading spreadsheet.  I wanted to know if there is an easy way to create a column of averages corresponding to each student, and couldn't find an answer/couldn't understand the syntax in the help section.  I understand how to go through and create an average for each row, but it seems like there has to be a way to highlight the entire data set and have it return a column of averages.  Thanks!
following is a solution to the problem