1 | Database_arr | ||||
|---|---|---|---|---|---|
2 | Key | Student ID | Class | Grade | |
3 | 1 | N1707 | 2012 | 85 | |
4 | 2 | N1327 | 2013 | 87 | |
5 | 3 | N1890 | 2012 | 79 | |
6 | 4 | N1122 | 2012 | 78 | |
7 | 5 | N1357 | 2013 | 81 | |
8 | 6 | N1652 | 2012 | 89 | |
9 | 7 | N7475 | 2013 | 92 | |
10 | 8 | N1314 | 2012 | 90 | |
11 | |||||
12 | |||||
13 | Criteria_arr | ||||
14 | Key | Student ID | Class | Grade | |
15 | 2012 | ||||
16 | |||||
17 | Result | Formula | |||
18 | 30.7 | =DVAR($A$2:$D$10, "Grade", $A$14:$D$15) | |||
19 | 30.7 | =DVAR($A$2:$D$10, D2, $A$14:$D$15) | |||
20 | 30.7 | =DVAR($A$2:$D$10, 4, $A$14:$D$15) | |||
21 | 30.7 | =DVAR('Student Grade'!$A$2:$D$10, "Grade", $A$14:$D$15) | |||
22 | |||||