Table Total adds automatic subtotaling to your spreadsheets — a feature professional data analysts rely on daily, now available directly in your sheets.

Select any column as a grouping key, choose an aggregation function, and the add-on inserts formula rows after each group in seconds. No manual work, no copy-paste, no broken formulas when your data changes.

What you can do:

Insert subtotal rows grouped by any column (Region, Category, Department, Date, etc.)
Choose from 11 functions: SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, VAR, VARP
Add a grand total row at the bottom of the table
Create collapsible row groups to fold and unfold sections
Replace existing subtotals with one click when your data updates
How it works:
The add-on inserts native SUBTOTAL(...) spreadsheet formulas — not static values. This means subtotals automatically exclude hidden rows when row groups are collapsed. The formulas remain fully functional even if the add-on is uninstalled.

Trial:
Every new user gets a 7-day free trial (only days you actually use the add-on count).

Privacy:
The add-on never reads or transmits your spreadsheet data to external servers. All operations happen locally within your spreadsheet environment.