Spreadsheet: 821840d1678931232-sumproduct-works-on-the-wrong-column-book2
Sheet: DATABASE Countries

 | INPUT IN YELLOW CELLS |  |  |  | MAIN CHANNELS
 |  |  |  |  | TOTAL
 | Country | INR | USD |  | Countries | Revenue
 | India | 236681.49 |  | 1 | Afghanistan |  |  | TOP 1 |  | #[NAME]!
 | United Kingdom | 5489.16 |  |  | Albania |  |  | TOP 2 | India | 236681.49
 |  |  |  |  | Algeria |  |  | TOP 3 | United Kingdom | 5489.16
 |  |  |  |  | American Samoa |  |  | TOP 4 | Albania | 0
 |  |  |  |  | Andorra |  |  | TOP 5 | Algeria | 0
 |  |  |  |  | Angola |  |  | TOP 6 | American Samoa | 0
 |  |  |  |  | Anguilla |  |  | TOP 7 | Andorra | 0
 |  |  |  |  | Antarctica |  |  | TOP 8 | Angola | 0
 |  |  |  |  | [NAME] |  |  | TOP 9 | Anguilla | 0
 |  |  |  |  | Argentina |  |  | TOP 10 | Antarctica | 0
 |  |  |  |  | Armenia |  |  | TOP 11 | [NAME] | 0
 |  |  |  |  | Aruba |  |  | TOP 12 | Argentina | 0
 |  |  |  |  | Australia |  |  | TOP 13 | Armenia | 0
 |  |  |  |  | Austria |  |  | TOP 14 | Aruba | 0
 |  |  |  |  | Azerbaijan |  |  | TOP 15 | Australia | 0
 |  |  |  |  | Bahamas |  |  |  | Austria | 0
 |  |  |  |  | Bahrain |  |  |  | Azerbaijan | 0
 |  |  |  |  | Bangladesh |  |  |  | Bahamas | 0
 |  |  |  |  | Barbados |  |  |  | Bahrain | 0
 |  |  |  |  | Belarus |  |  |  | Bangladesh | 0
 |  |  |  |  | Belgium |  |  |  | Barbados | 0
 |  |  |  |  | Belize |  |  |  | Belarus | 0
 |  |  |  |  | Benin |  |  |  | Belgium | 0
 |  |  |  |  | Bermuda |  |  |  | Belize | 0
 |  |  |  |  | Bhutan |  |  |  | Benin | 0
 |  |  |  |  | Bolivia |  |  |  | Bermuda | 0
 |  |  |  |  | Bosnia And Herzegowina |  |  |  | Bhutan | 0
 |  |  |  |  | Botswana |  |  |  | Bolivia | 0
 |  |  |  |  | Bouvet Island |  |  |  | Bosnia And Herzegowina | 0
 |  |  |  |  | Brazil |  |  |  | Botswana | 0
 |  |  |  |  | British Indian Ocean Territory |  |  |  | Bouvet Island | 0
 |  |  |  |  | [NAME] |  |  |  | Brazil | 0
 |  |  |  |  | Bulgaria |  |  |  | British Indian Ocean Territory | 0
 |  |  |  |  | [NAME] |  |  |  | [NAME] | 0
 |  |  |  |  | Burundi |  |  |  | Bulgaria | 0
 |  |  |  |  | Cambodia |  |  |  | [NAME] | 0
 |  |  |  |  | Cameroon |  |  |  | Burundi | 0
 | Thailand | THB | 33 |  | Canada |  |  |  | Cambodia | 0
 | Vietnam | VND | 22000 |  | Cape Verde |  |  |  | Cameroon | 0
 | India | INR | 70 |  | Cayman Islands |  |  |  | Canada | 0
 | Indonesia | IDR | 13500 |  | Central African Republic |  |  |  | Cape Verde | 0
 | Hong Kong | USD | 1 |  | Chad |  |  |  | Cayman Islands | 0
 | Turkey | USD | 1 |  | Chile |  |  |  | Central African Republic | 0
 | Russia | USD | 1 |  | China |  |  |  | Chad | 0
 | Oman | OMR | 0.38 |  | Christmas Island |  |  |  | Chile | 0
 | Laos | KIP | 15500 |  | Cocos (Keeling) Islands |  |  |  | China | 0
 |  |  |  |  | Colombia |  |  |  | Christmas Island | 0
 |  |  |  |  | Comoros |  |  |  | Cocos (Keeling) Islands | 0
 |  |  |  |  | Congo |  |  |  | Colombia | 0
 |  |  |  |  | Congo, The Drc |  |  |  | Comoros | 0
 |  |  |  |  | Cook Islands |  |  |  | Congo | 0
 |  |  |  |  | Costa Rica |  |  |  | Congo, The Drc | 0
 |  |  |  |  | [NAME] |  |  |  | Cook Islands | 0
 |  |  |  |  | Croatia (Local Name: [NAME]) |  |  |  | Costa Rica | 0
 |  |  |  |  | Cuba |  |  |  | [NAME] | 0
 |  |  |  |  | Cyprus |  |  |  | Croatia (Local Name: [NAME]) | 0
 |  |  |  |  | Czech Republic |  |  |  | Cuba | 0
 |  |  |  |  | Denmark |  |  |  | Cyprus | 0
 |  |  |  |  | Djibouti |  |  |  | Czech Republic | 0
 |  |  |  |  | Dominica |  |  |  | Denmark | 0
 |  |  |  |  | Dominican Republic |  |  |  | Djibouti | 0
 |  |  |  |  | East Timor |  |  |  | Dominica | 0
 |  |  |  |  | Ecuador |  |  |  | Dominican Republic | 0
 |  |  |  |  | Egypt |  |  |  | East Timor | 0
 |  |  |  |  | El Salvador |  |  |  | Ecuador | 0
 |  |  |  |  | Equatorial Guinea |  |  |  | Egypt | 0
 |  |  |  |  | Eritrea |  |  |  | El Salvador | 0
 |  |  |  |  | Estonia |  |  |  | Equatorial Guinea | 0
 |  |  |  |  | Ethiopia |  |  |  | Eritrea | 0
 |  |  |  |  | Falkland Islands (Malvinas) |  |  |  | Estonia | 0
 |  |  |  |  | Faroe Islands |  |  |  | Ethiopia | 0
 |  |  |  |  | Fiji |  |  |  | Falkland Islands (Malvinas) | 0
 |  |  |  |  | Finland |  |  |  | Faroe Islands | 0
 |  |  |  |  | France |  |  |  | Fiji | 0
 |  |  |  |  | France, Metropolitan |  |  |  | Finland | 0
 |  |  |  |  | French [NAME] |  |  |  | France | 0
 |  |  |  |  | French Polynesia |  |  |  | France, Metropolitan | 0
 |  |  |  |  | French Southern Territories |  |  |  | French [NAME] | 0
 |  |  |  |  | Gabon |  |  |  | French Polynesia | 0
 |  |  |  |  | Gambia |  |  |  | French Southern Territories | 0
 |  |  |  |  | Georgia |  |  |  | Gabon | 0
 |  |  |  |  | Germany |  |  |  | Gambia | 0
 |  |  |  |  | Ghana |  |  |  | Georgia | 0
 |  |  |  |  | Gibraltar |  |  |  | Germany | 0
 |  |  |  |  | Greece |  |  |  | Ghana | 0
 |  |  |  |  | Greenland |  |  |  | Gibraltar | 0
 |  |  |  |  | Grenada |  |  |  | Greece | 0
 |  |  |  |  | Guadeloupe |  |  |  | Greenland | 0
 |  |  |  |  | Guam |  |  |  | Grenada | 0
 |  |  |  |  | Guatemala |  |  |  | Guadeloupe | 0
 |  |  |  |  | Guinea |  |  |  | Guam | 0
 |  |  |  |  | Guinea-Bissau |  |  |  | Guatemala | 0
 |  |  |  |  | Guyana |  |  |  | Guinea | 0
 |  |  |  |  | Haiti |  |  |  | Guinea-Bissau | 0
 |  |  |  |  | Heard And Mc Donald Islands |  |  |  | Guyana | 0
 |  |  |  |  | Holy See (Vatican City State) |  |  |  | Haiti | 0
 |  |  |  |  | Honduras |  |  |  | Heard And Mc Donald Islands | 0
 |  |  |  |  | Hong Kong |  |  |  | Holy See (Vatican City State) | 0
 |  |  |  |  | Hungary |  |  |  | Honduras | 0
 |  |  |  |  | Iceland |  |  |  | Hong Kong | 0
 |  |  |  |  | India |  |  |  | Hungary | 0
 |  |  |  |  | Indonesia |  |  |  | Iceland | 0
 |  |  |  |  | Iran (Islamic Republic Of) |  |  |  | Indonesia | 0
 |  |  |  |  | Iraq |  |  |  | Iran (Islamic Republic Of) | 0
 |  |  |  |  | Ireland |  |  |  | Iraq | 0
 |  |  |  |  | Israel |  |  |  | Ireland | 0
 |  |  |  |  | Italy |  |  |  | Israel | 0
 |  |  |  |  | Jamaica |  |  |  | Italy | 0
 |  |  |  |  | Japan |  |  |  | Jamaica | 0
 |  |  |  |  | Jordan |  |  |  | Japan | 0
 |  |  |  |  | Kazakhstan |  |  |  | Jordan | 0
 |  |  |  |  | Kenya |  |  |  | Kazakhstan | 0
 |  |  |  |  | Kiribati |  |  |  | Kenya | 0
 |  |  |  |  | Korea, D.P.R.O. |  |  |  | Kiribati | 0
 |  |  |  |  | Korea |  |  |  | Korea, D.P.R.O. | 0
 |  |  |  |  | Kossovo |  |  |  | Korea | 0
 |  |  |  |  | Kuwait |  |  |  | Kossovo | 0
 |  |  |  |  | Kyrgyzstan |  |  |  | Kuwait | 0
 |  |  |  |  | Laos |  |  |  | Kyrgyzstan | 0
 |  |  |  |  | Latvia |  |  |  | Laos | 0
 |  |  |  |  | Lebanon |  |  |  | Latvia | 0
 |  |  |  |  | [NAME] |  |  |  | Lebanon | 0
 |  |  |  |  | Liberia |  |  |  | [NAME] | 0
 |  |  |  |  | Libyan Arab Jamahiriya |  |  |  | Liberia | 0
 |  |  |  |  | [NAME] |  |  |  | Libyan Arab Jamahiriya | 0
 |  |  |  |  | Lithuania |  |  |  | [NAME] | 0
 |  |  |  |  | Luxembourg |  |  |  | Lithuania | 0
 |  |  |  |  | Macau |  |  |  | Luxembourg | 0
 |  |  |  |  | Macedonia |  |  |  | Macau | 0
 |  |  |  |  | Madagascar |  |  |  | Macedonia | 0
 |  |  |  |  | [NAME] |  |  |  | Madagascar | 0
 |  |  |  |  | Malaysia |  |  |  | [NAME] | 0
 |  |  |  |  | Maldives |  |  |  | Malaysia | 0
 |  |  |  |  | [NAME] |  |  |  | Maldives | 0
 |  |  |  |  | Malta |  |  |  | [NAME] | 0
 |  |  |  |  | Marshall Islands |  |  |  | Malta | 0
 |  |  |  |  | Martinique |  |  |  | Marshall Islands | 0
 |  |  |  |  | Mauritania |  |  |  | Martinique | 0
 |  |  |  |  | [NAME] |  |  |  | Mauritania | 0
 |  |  |  |  | Mayotte |  |  |  | [NAME] | 0
 |  |  |  |  | Mexico |  |  |  | Mayotte | 0
 |  |  |  |  | Micronesia, Federated States Of |  |  |  | Mexico | 0
 |  |  |  |  | Moldova, Republic Of |  |  |  | Micronesia, Federated States Of | 0
 |  |  |  |  | Monaco |  |  |  | Moldova, Republic Of | 0
 |  |  |  |  | Mongolia |  |  |  | Monaco | 0
 |  |  |  |  | Montenegro |  |  |  | Mongolia | 0
 |  |  |  |  | Montserrat |  |  |  | Montenegro | 0
 |  |  |  |  | Morocco |  |  |  | Montserrat | 0
 |  |  |  |  | Mozambique |  |  |  | Morocco | 0
 |  |  |  |  | Myanmar (Burma) |  |  |  | Mozambique | 0
 |  |  |  |  | Namibia |  |  |  | Myanmar (Burma) | 0
 |  |  |  |  | Nauru |  |  |  | Namibia | 0
 |  |  |  |  | Nepal |  |  |  | Nauru | 0
 |  |  |  |  | Netherlands |  |  |  | Nepal | 0
 |  |  |  |  | Netherlands Antilles |  |  |  | Netherlands | 0
 |  |  |  |  | New Caledonia |  |  |  | Netherlands Antilles | 0
 |  |  |  |  | New Zealand |  |  |  | New Caledonia | 0
 |  |  |  |  | Nicaragua |  |  |  | New Zealand | 0
 |  |  |  |  | [NAME] |  |  |  | Nicaragua | 0
 |  |  |  |  | Nigeria |  |  |  | [NAME] | 0
 |  |  |  |  | Niue |  |  |  | Nigeria | 0
 |  |  |  |  | Norfolk Island |  |  |  | Niue | 0
 |  |  |  |  | Northern Mariana Islands |  |  |  | Norfolk Island | 0
 |  |  |  |  | Norway |  |  |  | Northern Mariana Islands | 0
 |  |  |  |  | Oman |  |  |  | Norway | 0
 |  |  |  |  | Pakistan |  |  |  | Oman | 0
 |  |  |  |  | Palau |  |  |  | Pakistan | 0
 |  |  |  |  | Panama |  |  |  | Palau | 0
 |  |  |  |  | [NAME] |  |  |  | Panama | 0
 |  |  |  |  | Paraguay |  |  |  | [NAME] | 0
 |  |  |  |  | Peru |  |  |  | Paraguay | 0
 |  |  |  |  | Philippines |  |  |  | Peru | 0
 |  |  |  |  | Pitcairn |  |  |  | Philippines | 0
 |  |  |  |  | Poland |  |  |  | Pitcairn | 0
 |  |  |  |  | Portugal |  |  |  | Poland | 0
 |  |  |  |  | Puerto Rico |  |  |  | Portugal | 0
 |  |  |  |  | Qatar |  |  |  | Puerto Rico | 0
 |  |  |  |  | Reunion |  |  |  | Qatar | 0
 |  |  |  |  | Romania |  |  |  | Reunion | 0
 |  |  |  |  | Russian Federation |  |  |  | Romania | 0
 |  |  |  |  | Rwanda |  |  |  | Russian Federation | 0
 |  |  |  |  | [NAME] Nevis |  |  |  | Rwanda | 0
 |  |  |  |  | [NAME] |  |  |  | [NAME] Nevis | 0
 |  |  |  |  | [NAME] And The Grenadines |  |  |  | [NAME] | 0
 |  |  |  |  | Samoa |  |  |  | [NAME] And The Grenadines | 0
 |  |  |  |  | [NAME] |  |  |  | Samoa | 0
 |  |  |  |  | Sao Tome And Principe |  |  |  | [NAME] | 0
 |  |  |  |  | Saudi Arabia |  |  |  | Sao Tome And Principe | 0
 |  |  |  |  | Senegal |  |  |  | Saudi Arabia | 0
 |  |  |  |  | Seychelles |  |  |  | Senegal | 0
 |  |  |  |  | Sierra Leone |  |  |  | Seychelles | 0
 |  |  |  |  | Singapore |  |  |  | Sierra Leone | 0
 |  |  |  |  | Slovakia (Slovak Republic) |  |  |  | Singapore | 0
 |  |  |  |  | Slovenia |  |  |  | Slovakia (Slovak Republic) | 0
 |  |  |  |  | Solomon Islands |  |  |  | Slovenia | 0
 |  |  |  |  | Somalia |  |  |  | Solomon Islands | 0
 |  |  |  |  | South Africa |  |  |  | Somalia | 0
 |  |  |  |  | South Georgia And South S.S. |  |  |  | South Africa | 0
 |  |  |  |  | Spain |  |  |  | South Georgia And South S.S. | 0
 |  |  |  |  | [NAME] |  |  |  | Spain | 0
 |  |  |  |  | St. Helena |  |  |  | [NAME] | 0
 |  |  |  |  | St. Pierre And Miquelon |  |  |  | St. Helena | 0
 |  |  |  |  | Sudan |  |  |  | St. Pierre And Miquelon | 0
 |  |  |  |  | Suriname |  |  |  | Sudan | 0
 |  |  |  |  | [NAME] And Jan Mayen Islands |  |  |  | Suriname | 0
 |  |  |  |  | Swaziland |  |  |  | [NAME] And Jan Mayen Islands | 0
 |  |  |  |  | Sweden |  |  |  | Swaziland | 0
 |  |  |  |  | Switzerland |  |  |  | Sweden | 0
 |  |  |  |  | Syrian Arab Republic |  |  |  | Switzerland | 0
 |  |  |  |  | Taiwan, Province Of China |  |  |  | Syrian Arab Republic | 0
 |  |  |  |  | Tajikistan |  |  |  | Taiwan, Province Of China | 0
 |  |  |  |  | Tanzania, United Republic Of |  |  |  | Tajikistan | 0
 |  |  |  |  | Thailand |  |  |  | Tanzania, United Republic Of | 0
 |  |  |  |  | Togo |  |  |  | Thailand | 0
 |  |  |  |  | Tokelau |  |  |  | Togo | 0
 |  |  |  |  | Tonga |  |  |  | Tokelau | 0
 |  |  |  |  | Trinidad And Tobago |  |  |  | Tonga | 0
 |  |  |  |  | Tunisia |  |  |  | Trinidad And Tobago | 0
 |  |  |  |  | Turkey |  |  |  | Tunisia | 0
 |  |  |  |  | Turkmenistan |  |  |  | Turkey | 0
 |  |  |  |  | Turks And Caicos Islands |  |  |  | Turkmenistan | 0
 |  |  |  |  | Tuvalu |  |  |  | Turks And Caicos Islands | 0
 |  |  |  |  | Uganda |  |  |  | Tuvalu | 0
 |  |  |  |  | Ukraine |  |  |  | Uganda | 0
 |  |  |  |  | United Arab Emirates |  |  |  | Ukraine | 0
 |  |  |  |  | United Kingdom |  |  |  | United Arab Emirates | 0
 |  |  |  |  | United States |  |  |  | United States | 0
 |  |  |  |  | U.S. Minor Islands |  |  |  | U.S. Minor Islands | 0
 |  |  |  |  | Uruguay |  |  |  | Uruguay | 0
 |  |  |  |  | Uzbekistan |  |  |  | Uzbekistan | 0
 |  |  |  |  | [NAME] |  |  |  | [NAME] | 0
 |  |  |  |  | Venezuela |  |  |  | Venezuela | 0
 |  |  |  |  | VietNam |  |  |  | VietNam | 0
 |  |  |  |  | Virgin Islands (British) |  |  |  | Virgin Islands (British) | 0
 |  |  |  |  | Virgin Islands (U.S.) |  |  |  | Virgin Islands (U.S.) | 0
 |  |  |  |  | [NAME] |  |  |  | [NAME] | 0
 |  |  |  |  | Western Sahara |  |  |  | Western Sahara | 0
 |  |  |  |  | Yemen |  |  |  | Yemen | 0
 |  |  |  |  | Zambia |  |  |  | Zambia | 0
 |  |  |  |  | Zimbabwe |  |  |  | Zimbabwe | 0
 |  |  |  |  | Other |  |  |  | Other | 0