How to get multiple values of Vlookup in Single Cell

[Henriksen]

I have found several items close to what i need but nothing exact. I need to perform a vlookup consisting of multiple values (names of cities) then return the sum of that result into a single cell. Is this possible? brand new to vlookup so dummy it down for me, please.

[Gania]

Take a look SUMIF function in Help menu.

[Alfons]

But i'm seeing a return of 0 when total should be 6332; where am I going wrong with my formula : =SUMIF([PremTech.xls]Summary!$A$2:$B$117,AD8:AD16,[PremTech.xls]Summary!$B$2:$B$117)

[JustineBB]

If this is what you have:

• ...........A.............B
• 1..Pittsburgh......10
• 2. Baltimore.......0
• 3..Pittsburgh......20
• 4..Cleveland......0
• 5..Cincinnati......-5

And you want to sum values that correspond to Pittsburgh: =SUMIF($A$1:$A$5,"Pittsburgh",$B$1:$B$5) Better to use cells to hold the criteria: D1 = Pittsburgh =SUMIF($A$1:$A$5,D1,$B$1:$B$5).

[-Deven-]

I have multiple values to lookup...i.e., alpharetta, austin, bakersfield, carrollton...i want to search for all of those and return the sum into a single cell :

• City Customers
• Alpharetta 2394
• Anaheim 665
• Antioch 482
• Austin 356
• Bakersfield 794
• Boca Raton 363
• Brunswick 142
• Buena Park 339
• Canoga Park 984
• Carrollton 540