title: Check if Cell value exists in Column and return a sum for a value in the same row but different column for each occurance
body: <p>My end goal is to have a Column of salesmen and they're total amount earned in the next Column. I have a data sheet that has their name next to each sale they made. So I want to consolidate to just their name and the total amount of their sales in a new table. The data table will continue to grow. </p>