Distinct SUM

Hi all,   I have a table with sales and their goal as per below:   Opp  Reps    Goal 1       Dave     500 2       Dave     500 3       Jane      500   The goal is the same for each rep ( $10...