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
cheers, christiaan
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.