Question about SUMIF

%3CLINGO-SUB%20id%3D%22lingo-sub-3128282%22%20slang%3D%22en-US%22%3EQuestion%20about%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3128282%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%60m%20still%20newbie%20at%20this%20community%2C%20but%20very%20appreciate%20if%20there%20is%2Fare%20anybody%20who%20can%20help%20me%20to%20solve%20the%20problem%20I%20have%20at%20my%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%60s%20say%20I%20have%20table%20A%20which%20has%20three%20items%20(City%20in%20the%20world)%20as%20below%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%2264%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2219%22%3EBandung%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3EJakarta%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3ENew%20York%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20I%20have%20table%20B%20which%20has%20items%20(city%20in%20the%20world)%20and%20every%20item%20has%20its%20quantity.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22141%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2277%22%3EBandung%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EJakarta%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENew%20York%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAmsterdam%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETokyo%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESeoul%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETurin%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(Question)%3C%2FP%3E%3CP%3Ein%20table%20B%2C%20I%20just%20want%20to%20sum%20every%20quantity%20which%20has%20similiar%20item%2F%20city%20in%20table%20A.%20(Bandung%20%3D10%2C%20Jakarta%3D9%2C%20New%20York%3D8%2C%20so%20the%20total%20is%2027).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3128282%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-3128401%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20about%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3128401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1299413%22%20target%3D%22_blank%22%3E%40akrimni%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DSUM(%20SUMIFS(%20TableB%7BQty%5D%2C%20TableB%5BCity%5D%2C%20TableA%5BCity%5D%20)%20)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello 

 

I`m still newbie at this community, but very appreciate if there is/are anybody who can help me to solve the problem I have at my work.

 

Let`s say I have table A which has three items (City in the world) as below

Bandung
Jakarta
New York

 

And I have table B which has items (city in the world) and every item has its quantity.

 

Bandung10
Jakarta9
New York8
Amsterdam7
Tokyo6
Seoul5
Turin4

 

(Question)

in table B, I just want to sum every quantity which has similiar item/ city in table A. (Bandung =10, Jakarta=9, New York=8, so the total is 27). 

1 Reply

@akrimni 

It could be

=SUM( SUMIFS( TableB{Qty], TableB[City], TableA[City] ) )