[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:

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	2627	December 3, 2020
How to sum a column only if a checkbox is not checked?	2	922	December 1, 2019
Getting sum of more than 2 columns of a row in another column Showcase	6	1489	March 16, 2020
Checkbox count in a table	1	3036	February 19, 2019
Calculate sum of ColumnA if ColumnB is unchecked	2	415	February 19, 2022

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

Related topics