N
Nathan
Hi,
I have a spreadsheet of a survey I conducted with teachers at various
schools. Across row 3 I have Name, School, and then all of the questions. In
row 4 down, I have all of the data. In row 2 I would like to calculate
averages for all of the answers. I am sorting (through auto filter) the data
by school, and would like to enter an average formula that adjusts every time
I sort by a different school. I think this uses an IF function, but am not
sure. Any thoughts?
Thanks, Nathan.
I have a spreadsheet of a survey I conducted with teachers at various
schools. Across row 3 I have Name, School, and then all of the questions. In
row 4 down, I have all of the data. In row 2 I would like to calculate
averages for all of the answers. I am sorting (through auto filter) the data
by school, and would like to enter an average formula that adjusts every time
I sort by a different school. I think this uses an IF function, but am not
sure. Any thoughts?
Thanks, Nathan.