Calculate sum of ColumnA if ColumnB is unchecked

I am so sorry to ask such a simple question. Somehow I struggle to make the formula right.

I want to calculate the sum of ColumnA (number type column) but only those rows where the ColumnB is unchecked (checkbox type column)

Here is where I am:

Table1.[ColumnA].SumIf(Table1.[ColumnB].Contains(false))

How can I refere to ColumnB correctly?

hi @Egyesek_Youth_Association ,

you can do it as below, using a filter instead of the SumIf(). It is worthwhile the effort to master filters quite a bit because they come in handy in most situation, even when you believe you need a kind of if statement :wink:

cheers, christiaan

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.