Spreadsheet: 813665d1673914547-using-averageif-with-cells-that-are-not-adjacent-master-grade-workbook-mock
Sheet: Cohort 2025

Cohorts Course Average on Written Exams (Enter in integer form out of 100: Do not enter a zero, this will mess up the averages: leave blank if no grade) Only Enter Values Under Exam or [NAME]: Averages Autocalculate
 | Summer 1 (Term 1) |  |  |  |  |  |  |  | Fall 1 (Term 2) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spring 1 (Term 3) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer 2 (Term 4) |  |  |  |  | Fall 2 (Term 5) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spring 2 (Term 6) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer 3 (Term 7) |  | Fall 3 (Term 8) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spring 3 (Term 9) |  | All Terms
Cohort | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Head |  |  |  | Class Name |  |  |  | Class Name | Class Name |  |  |  | Research I | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name |  |  |  | Class Name | Research II | Class Name |  |  |  | Class Name Class name |  |  |  | [NAME] | [NAME] | Class name |  |  |  | Class Name |  |  |  | Research III | Class Name | Class Name |  |  |  | Class name |  |  |  | Class Name | Class Name | [NAME] | [NAME] | Overall Average All Courses
 | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Grade | Exam 1 | Exam 2 | Exam 3 | [NAME] | Grade | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Grade | Grade | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Grade | Grade | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Grade | Grade | Exam 1 | Exam 2 | Exam 3 | [NAME] | Exam 1 | Exam 2 | Exam 3 | [NAME] | Grade | Grade
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Student 7
Student 8
Student 9
Student 10
Student 11
Student 12
Student 13
Student 14
Student 15
Student 16
Student 17
Student 18
Student 19
Student 20
Student 21
Student 22
Student 23
Student 24
Student 25
Student 26
Student 27
Student 28
Student 29
Student 30
Class Average
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fix This column
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cant determine how to not average zeros on non-ranged cells (Cells not next to each other)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AverageIF function doesn't work