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.