Apr 12 2019 08:17 AM
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.
Apr 12 2019 08:32 AM
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
Apr 16 2019 05:17 AM
@Sergei Baklan Thank you very much. The expression works perfectly.
Apr 16 2019 07:19 AM
@KC_86 , you are welcome
Apr 12 2019 08:32 AM
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