Calculate sum of ColumnA if ColumnB is unchecked

[Egyesek_Youth_Association]

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?

[Christiaan_Huizer]

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

cheers, christiaan