Available functions in Table Total

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

Note

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.