How to Add Sum Calculations in a Confluence Table Easily 2026

From an existing Confluence page — in this case one already containing a Databases-style table with fields and tags — insert or open the Elements Spreadsheets macro. Confluence shows a brief loading state while the macro initializes, with an Update and Cancel option in the modal header and the underlying page (with its own "DATA BASE" table and tag fields like "Not started" and "Done") still visible behind it. This confirms the macro lives inside your page rather than as a separate file — the totals you calculate stay attached to the document your team already reads.

Once the macro opens, it behaves like a standard spreadsheet grid with lettered columns and numbered rows, plus its own toolbar for fonts, cell formatting, alignment, and functions. Set up your headers in row 1 — ID, Number 1, Age, Sum — and fill in the rows beneath with your actual values. Unlike a plain Confluence table, every cell here can hold either a value or a formula, which is what makes the sum calculation possible in the next step.

Click into the Sum cell for a row and type an equals sign to start a formula, referencing a range of cells you want added together — for example =A2:A6 to sum every value in that column from row 2 through row 6. The formula bar shows exactly what you've typed as you build it, with red and green buttons to cancel or confirm once the range looks right. This is the core difference from a static table: the total isn't typed in by hand, it's calculated live from the cells you point it at, so editing any number in the range updates the sum automatically.

Click the green checkmark to lock in the formula. The Sum cell then displays the calculated total instead of the formula text, and the underlying formula stays attached to the cell — click back into it later and you'll see =A2:A6 again rather than a hardcoded number. If you add a new row of data inside that range, the sum updates on its own the next time the sheet recalculates, which is the entire point of using a spreadsheet macro instead of manually retyping a total every time the numbers change.

Once the formula and totals look correct, click Update in the macro's modal header (visible next to Cancel while the macro loads) to save the spreadsheet back into the page, then publish the page itself if you haven't already. The macro's data is stored as part of the page content, so anyone opening it afterward sees the same live totals without needing edit access to the spreadsheet themselves.

If your needs are simpler — one running total on a small table rather than a full spreadsheet with multiple formulas — Confluence's native Databases feature has its own built-in Calculate option that can add a Sum to the bottom of a numeric column without embedding a separate macro at all. It's less powerful than Elements Spreadsheets (no arbitrary formulas, just aggregate functions like sum, average, and count), but it's faster to set up when a single column total is all you actually need.