SUMIF/SUMIFS Expressions for matching cell values.

[KC_86]

Hello!

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.

[#2 · Accepted solution]

@KC_86 , it could be

=SUMIF(PART!$A$2:$A$370,A2,PART!$B$2:$B$370)

In your sample Person ID:s are different in both sheets, thus result is zero

[#3]

@Sergei Baklan Thank you very much. The expression works perfectly. 

[#4]

@KC_86 , you are welcome