Easy Tech TutsHow to Add Sum Calculations in a Confluence Table Easily 2026
By Impran M NLast checked against official docs
A plain Confluence table can hold numbers, but nothing on the page adds them up for you; there's no formula bar on a standard table cell. The Elements Spreadsheet macro fixes that by embedding an Excel-like spreadsheet inside your page, with cell references, functions, and its own formula bar.
This guide covers opening that macro, entering a real SUM formula against a range of cells, and getting a live total that updates with your data. It ends with Confluence's native Databases feature, a lighter option worth knowing about before you reach for a macro at all.
01Open the spreadsheet macro from your page
From an existing Confluence page, in this case one already built as a Databases-style table with fields and status tags, insert or open the Elements Spreadsheet macro. Confluence shows a brief loading state while it initializes, with Update and Cancel sitting in the modal header and the page's own table still visible behind it. That confirms the macro's data lives inside the page itself, not as a separate attached file.
02Lay out your columns
Once the macro opens, it behaves like a standard spreadsheet grid: lettered columns, numbered rows, and a toolbar for fonts, cell formatting, alignment, and functions. Set up headers in row 1, for example ID, Number 1, Age, Sum, and fill in the rows beneath with your actual values. Every cell here can hold a value or a formula, which is what makes the next step possible.
03Write a SUM formula against the range, then confirm it
Click into the Sum cell for a row and type an equals sign to start a formula. Put the range inside the SUM function instead of typing the range on its own: =SUM(A2:A6) adds every value in that column from row 2 through row 6.
A bare range reference like =A2:A6 is not a total in Elements Spreadsheet. The macro's own documentation shows formulas built around named functions, so SUM has to be there.
The formula bar shows exactly what you've typed, with a green check to confirm and a red X to cancel. Confirm it and the Sum cell shows the calculated total, not the formula text.
Click back into the cell later and it still shows =SUM(A2:A6), not a hardcoded number. Add a new row inside that range, and the total updates on its own the next time the sheet recalculates.
04Update the page to save your changes
Click Update in the macro's modal header 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.
05Know the lighter, native alternative
If a full spreadsheet is more than you need, Confluence's own Databases feature has a built-in Calculate option: select it below any field on a database block and choose Sum, Average, Min, Max, Count values, Count unique values, Count empty, or Percent empty. It only aggregates a whole column; there's no per-row math, so nothing built into Confluence can multiply a price column by a quantity column the way a spreadsheet formula can. For one running total on a small table, it's faster to set up than installing a macro at all.
| Elements Spreadsheet macro | Databases Calculate | |
|---|---|---|
| Formula support | 400+ functions (SUM, IF, VLOOKUP, COUNTIF, and more), written like Excel | None; a fixed list of aggregate calculations only |
| Per-row math | Yes, one cell can reference others, e.g. price times quantity | No, calculations run on a whole column only |
| Where it lives | Third-party macro from the Atlassian Marketplace (Elements Apps) | Built into Confluence Cloud, nothing to install |
| Best for | Multiple formulas in one embedded spreadsheet | A single quick total at the bottom of a database column |
Marketplace pricing and availability can change; check the Elements Spreadsheet listing on the Atlassian Marketplace for current terms.
When it doesn't work
Typing =A2:A6 into a cell doesn't produce a total
Why: Elements Spreadsheet treats a bare range as a reference, not a calculation. A range needs to sit inside a function to do anything with it.
Fix: Wrap it in the SUM function: =SUM(A2:A6).
The total didn't change after a new row of data was added
Why: The new row sits outside the range the formula points at.
Fix: Edit the formula to extend the range, or build it against a few extra blank rows up front so future entries fall inside it automatically.
There's no Calculate option under a column
Why: Calculate only appears on Confluence's native Database blocks. A plain table, or a table inside the Elements Spreadsheet macro, doesn't have it.
Fix: Convert the table to a Database block if the built-in aggregate option is what you're after, or stay with the macro's own SUM formula.
Frequently asked questions
Can a regular Confluence table calculate a sum on its own?
No, a plain table has no formula support. A real sum needs either the Elements Spreadsheet macro, which embeds a full spreadsheet in the page, or Confluence's native Databases feature, which has a simpler built-in Calculate option.
How do I write a sum formula in the Elements Spreadsheet macro?
Click into the target cell, type =SUM( followed by the cell range, for example =SUM(A2:A6), close the parenthesis, and confirm with the green checkmark. A bare range without SUM() won't total anything.
Does the sum update automatically if I change the data?
Yes, as long as the changed cells fall inside the range the formula references. The formula stays attached to the cell instead of being replaced by a static number.
Do I need to publish the page after editing the spreadsheet macro?
Yes. Click Update in the macro to save the changes into the page content, then publish the page so the updated totals are visible to everyone with access.
What's the difference between Elements Spreadsheet and Confluence's native Databases Calculate option?
Elements Spreadsheet is a full Excel-like macro with 400+ functions. Databases Calculate is built into Confluence and limited to a fixed set of aggregates: Sum, Average, Min, Max, and a few count variants, applied to one column at a time.
Sources and last check
Click path and screens come from a walkthrough of the Elements Spreadsheet macro. Formula syntax was re-checked against Elements Apps' own documentation in September 2026, which corrected the article's earlier instruction to type a bare range (=A2:A6) as a sum; the macro requires the SUM function, so the correct formula is =SUM(A2:A6). The list of calculation types under Confluence's native Databases Calculate option was also verified against Atlassian's official support documentation and expanded to match what it offers (Sum, Average, Min, Max, and four count variants, not just sum/average/count).
About the author
Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.
