aggregate | subTotal | |
| average | 1 | 1 |
| count | 2 | 2 |
| countA | 3 | 3 |
| max | 4 | 4 |
| min | 5 | 5 |
| product | 6 | 6 |
| stddev.s | 7 | 7 |
| stddev.p | 8 | 8 |
| sum | 9 | 9 |
| var.s | 10 | 10 |
| var.p | 11 | 11 |
| median | 12 | |
| mode.sngl | 13 | |
| large | 14 | |
| small | 15 | |
| percentile.inc | 16 | |
| quartile.inc | 17 | |
| percentile.exc | 18 | |
| quartile.exc | 19 |
subTotal allows to add 100 to its function number which causes the function to not ignore hidden rows (or columns). With 100 added, it behaves equal to aggregate