SOLVED
Home

SUMIF/SUMIFS Expressions for matching cell values.

%3CLINGO-SUB%20id%3D%22lingo-sub-445837%22%20slang%3D%22en-US%22%3ESUMIF%2FSUMIFS%20Expressions%20for%20matching%20cell%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-445837%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20need%20help%20with%20an%20Excel%20expression.%20I%20have%20an%20excel%20with%20two%20sheets%2C%20Sheet%20PID%20and%20Sheet%20PART.%3CBR%20%2F%3ESheet%20PID%20has%20two%20columns%2C%20Person%20ID%20and%20Accumulated%20Points.%3CBR%20%2F%3ESheet%20PART%20has%20two%20columns%2C%20Person%20ID%20and%20Points.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20like%20to%20SUM%20all%20the%20points%20that%20the%20same%26nbsp%3BPerson%20ID%20collected%2Faccumulated%20and%20show%20the%20total%20points%20in%20the%20Accumulated%20Points%20column.%20How%20can%20I%20do%20that%3F%20Please%20advise.%20Thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-445837%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-446031%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%2FSUMIFS%20Expressions%20for%20matching%20cell%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-446031%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320138%22%20target%3D%22_blank%22%3E%40KC_86%3C%2FA%3E%26nbsp%3B%2C%20it%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DSUMIF(PART!%24A%242%3A%24A%24370%2CA2%2CPART!%24B%242%3A%24B%24370)%3C%2FPRE%3E%0A%3CP%3EIn%20your%20sample%20Person%20ID%3As%20are%20different%20in%20both%20sheets%2C%20thus%20result%20is%20zero%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-460034%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%2FSUMIFS%20Expressions%20for%20matching%20cell%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-460034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much.%20The%20expression%20works%20perfectly.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-460891%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%2FSUMIFS%20Expressions%20for%20matching%20cell%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-460891%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320138%22%20target%3D%22_blank%22%3E%40KC_86%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
KC_86
Occasional Contributor

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.

 

3 Replies
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

 

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

@KC_86 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies