1 | Function | Code (includes hidden values) | Code (ignores hidden values) | |
---|---|---|---|---|
2 | AVERAGE | 1 | 101 | |
3 | COUNT | 2 | 102 | |
4 | COUNTA | 3 | 103 | |
5 | MAX | 4 | 104 | |
6 | MIN | 5 | 105 | |
7 | PRODUCT | 6 | 106 | |
8 | STDEV | 7 | 107 | |
9 | STDEVP | 8 | 108 | |
10 | SUM | 9 | 109 | |
11 | VAR | 10 | 110 | |
12 | VARP | 11 | 111 | |
13 |
1 | Student ID | Student Name | Major | Class Year | Midterm Grade | Final Grade | |
---|---|---|---|---|---|---|---|
2 | N1304 | David | Computer Science | 2012 | 78 | 81 | |
3 | N1008 | Jason | Math | 2011 | 87 | 80 | |
4 | N1866 | Mary | Computer Science | 2012 | 79 | 80 | |
5 | N1774 | Rob | Computer Science | 2012 | 90 | 85 | |
6 | N1365 | Jason | Math | 2011 | 90 | 96 | |
7 | |||||||
8 | |||||||
9 | function | function_code | Result | Formula | |||
10 | AVERAGE | 1 | 84.4 | =SUBTOTAL(B10,$F$2:$F$6) | |||
11 | MAX | 4 | 96 | =SUBTOTAL(B11,$F$2:$F$6) | |||
12 | MIN | 5 | 80 | =SUBTOTAL(B12,$F$2:$F$6) | |||
13 | STDEV | 7 | 6.804410334 | =SUBTOTAL(B13,$F$2:$F$6) | |||
14 | SUM | 9 | 422 | =SUBTOTAL(B14,$F$2:$F$6) | |||
15 | VAR | 10 | 46.3 | =SUBTOTAL(B15,$F$2:$F$6) | |||
16 |
1 | Month | Deputy | Department | Sales | ||
---|---|---|---|---|---|---|
2 | January | David | Electronics | $2,500.00 | ||
3 | January | John | Office Products | $890.00 | ||
4 | Feburary | Mary | Electronics | $3,300.00 | ||
5 | Feburary | Jason | Books | $1,060.00 | ||
6 | Feburary | Rob | Beauty | $1,425.00 | ||
7 | March | Tom | Electronics | $780.00 | ||
8 | March | Jack | Books | $900.00 | ||
9 | ||||||
10 | ||||||
11 | Month | Deputy | Department | Sales | ||
12 | January | David | Electronics | $2,500.00 | ||
13 | January | John | Office Products | $890.00 | ||
14 | Feburary | Mary | Electronics | $3,300.00 | ||
17 | March | Tom | Electronics | $780.00 | ||
19 | ||||||
20 | ||||||
21 | Function | Result | Formula | |||
22 | SUM | $7,470 | =SUBTOTAL(VLOOKUP(A22, 'Function Code'!$A$2:$C$12, 3, FALSE), D11:D) | |||
23 |