Thanks for your anwser but that's not the result i'm looking for.
I want to Sum the points but the points for each TransID can only be counted once and then I want to apply the condition.
To help explaining, I have a Table (QVD) with my sales. Each sale has a TransID. However a sale has multiple rows, one for every product sold in that especific sale and I only want to count the points for that sale once.