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,...
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
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