How to compute totals in Excel / Spreadsheets when Carbone injects new lines?
Most spreadsheet reports need totals at the bottom of the table.
But the bottom of the table is dynamically pushed down by Carbone when the data is inserted.
So you cannot use a formula =SUM(B1:B2) because B2 is dynamic. It can be B88 or B351 when Carbone has inserted the data.
Here are two solutions:
Use a dynamic Excel formula
Place this formula in any summary cell in your template worksheet, and it will produce the sum of all the numbers in the column above that cell:
Make sure that your Carbone tags end with the formatN formatter to convert numeric values to Excel numbers. Otherwise, the formula will not work.
Use Carbone aggregators
Carbone can compute the total itself
Updated on: 09/29/2023