Multiple VLOOKUP In Single Function

**ComradeBT** · 06-15-2010, 07:04 PM

Hope someone can help me on this

(Please see attached .xls file)

I wish to reference and return the sum of a ranking score given against a country name into one, single cell on another excel sheet.

For example, in the attached file the Netherlands appears 3 times and has ranking sum of 2144. Am I able to return this sum via a vlookup or similar function into a single cell on another sheet?

Please help!

Thanks.

**daddylonglegs** · 06-15-2010, 07:34 PM

Try using SUMIF function, i.e.

=SUMIF(A:A,"Netherlands",B:B)

You can put the country name in a cell, e.g. D2 then that formula becomes

=SUMIF(A:A,D2,B:B)