Forum Discussion
Solved
SUMIF/SUMIFS Expressions for matching cell values.
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.
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 Replies
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
SergeiBaklan Thank you very much. The expression works perfectly.
KC_86 , you are welcome
