I would like to create a subtotal in a column as I need this subtotal number for a calculation. Code does seem to have a Sum command, but no way to designate which cells I want to include. In Excel, I would do something like =sum(b2:b5) to sum up a partial column.
How do I do this in Coda? There don’t seem to be the standard Column indicators A, B, C across the top.
1 Like
You can do this by specifying an aggregate for the column and using groups to create subtotals.
A bit like this…
A table is set up and a total provided for the entire column. Below it is a view of the same table with grouping used to create subtotals.
Table 2 contains calculated subtotals for each category that you can reference in other formulae if you wish.
1 Like