How do I add total sum of columns in a cell?
-
Hello,
We’re trying to automate a total number on table.
Q: How do we add total sum of columns in the last cell?
What we’re trying to achieve:
1) A financial table with rows that looks like this (also see attachment):
Month | 2020 | 2021 | YoY Change | YoY%
Jan | 5,000 | 1,500 | 3,500 | 30%
Feb | 3,000 | 1,600 | 1,400 | 53.33%
etc
etc
Dec
Total | {{sum 2020}} | {{ sum 2021 }} | etc
2) After Dec, we have “Total”, in this row want to add the total of the adjacent cells without entering / calculating manually.
3) “Calculation total: Calculate a total for this column”
adds it own row, doesn’t have Total label, and includes symbols such as “∑ = ” we don’t need.
Is this possible?
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘How do I add total sum of columns in a cell?’ is closed to new replies.
