Products › Table Total
Table Total
v1.0for Google SheetsAuto-insert SUBTOTAL rows grouped by any column. Native Google Sheets formulas — they work even without the add-on installed.
Just released
Aggregation functions
Table Total supports the following functions for calculating subtotals. Each function corresponds to a standard Google Sheets SUBTOTAL function code.
| Function | Description | Best used for |
|---|---|---|
| SUM | Sum of all values in the group | Sales totals, revenue, quantities |
| AVERAGE | Arithmetic mean of all values | Scores, ratings, averages |
| COUNT | Count of cells containing numbers | Counting numeric entries |
| COUNTA | Count of all non-empty cells | Counting any non-blank entries |
| MAX | Largest value in the group | Finding peaks, highest scores |
| MIN | Smallest value in the group | Finding minimums, lowest prices |
| PRODUCT | Product of all values | Compound factors, multiplications |
| STDEV | Sample standard deviation | Statistical spread in a sample |
| STDEVP | Population standard deviation | Statistical spread of a full population |
| VAR | Sample variance | Variance in a sample |
| VARP | Population variance | Variance of a full population |
All functions use the SUBTOTAL formula internally, which means they
automatically ignore hidden rows when row groups are collapsed in Google
Sheets. This ensures your subtotals always reflect visible data only.
Choosing the right function
- SUM — the most common choice for numeric data like sales, costs, or units.
- AVERAGE — useful when you need the mean value per group rather than the total.
- COUNT / COUNTA — use COUNT for numbers only, COUNTA for any non-empty cell.
- MAX / MIN — use to quickly find the highest or lowest value in each group.
- STDEV / VAR — use for statistical analysis of data distribution within groups.
How the SUBTOTAL formula works
Table Total inserts formulas in the form:
=SUBTOTAL(fnCode, range)
Where fnCode is a number corresponding to the function:
| Code | Function |
|---|---|
| 1 | AVERAGE |
| 2 | COUNT |
| 3 | COUNTA |
| 4 | MAX |
| 5 | MIN |
| 6 | PRODUCT |
| 7 | STDEV |
| 8 | STDEVP |
| 9 | SUM |
| 10 | VAR |
| 11 | VARP |
This means the inserted formulas are native Google Sheets formulas — they remain fully functional even if you uninstall the add-on.