Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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
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
No comments:
Post a Comment