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