Sum for Subtotals

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