I need help with an Excel expression. I have an excel with two sheets, Sheet PID and Sheet PART. Sheet PID has two columns, Person ID and Accumulated Points. Sheet PART has two columns, Person ID and Points.
I would like to SUM all the points that the same Person ID collected/accumulated and show the total points in the Accumulated Points column. How can I do that? Please advise. Thank you.