[Screen Shot 2021-01-22 at 8.00.44 AM] Is there a relatively simple formula for adding the value of column 2 IF column 3 is checked? I tried: SumIf(TEST.[Column 2],TEST.[Column 3]=true) That returns zero. I can’t seem to find an expression that successfully checks if column 3 is check or not. A…

Hey Jason, I think the filter formula is your friend here. Take a look at this example:

Hey, thanks for the reply! Unfortunately, that’s not quite what I’m looking for. I’m not interested in how many rows are checked and that seem the be what is produced from that formula. In the picture above I want the SUM() of column 2, but only for rows where column 3 is checked. Thanks!

That’s exactly what I’m looking for and it works perfectly. Thanks you! I had built a solution that involved a reference table that did the filtering then ran the sum() on that filtered table, but this is MUCH easier.

You’re welcome! Filter works for so many cases. It’s the Swiss army knife of Coda formulas.

Formula that adds up the value of rows that have a checked box

Johg_Ananda January 22, 2021, 6:55pm 2

Hey @Jason_Guerra there isn’t a clean answer to this. There are some ways to hack around it that have been discussed on the community. My post here will set you on the hunt:

Topic		Replies	Views
Tally up all check boxes in a row	5	2784	December 3, 2020
How to map all the checkboxes in a row and sum the ones checked	8	2085	April 18, 2022
Calculate sum of ColumnA if ColumnB is unchecked	1	494	February 19, 2022
Checkbox count in a table	1	3135	February 19, 2019
How to sum a column only if a checkbox is not checked?	2	978	December 1, 2019

Formula that adds up the value of rows that have a checked box

Related topics