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.

Any help would be much appreciated.