Spreadsheet: 81433d1281615082-sum-if-another-example-sum-if-criteria
Sheet: Sheet1

Country | Total |  |  |  |  |  |  |  |  | Using Pivot Table
ALBANIA | 4458291.93939392 |  |  |  |  |  |  |  |  | Sum of Total
ALBANIA | 9653997.68484846 |  |  |  |  |  | Country | Using SUMIF Formula |  | Country | Total
ARMENIA | 8788046.72727269 |  |  |  |  |  | ALBANIA |  |  | ALBANIA | 14112289.62424238
AUSTRIA | 2293414.54545454 |  |  |  |  |  | ARMENIA |  |  | ARMENIA | 8788046.72727269
AUSTRIA | 7705608.03030301 |  |  |  |  |  | AUSTRIA |  |  | AUSTRIA | 9999022.57575755
AZERBAIJAN | 1860439.06666666 |  |  |  |  |  | AZERBAIJAN |  |  | AZERBAIJAN | 13895801.88484846
AZERBAIJAN | 12035362.8181818 |  |  |  |  |  | BAHAMAS |  |  | BAHAMAS | 6839657.07272725
BAHAMAS | 6839657.07272725 |  |  |  |  |  | BELARUS |  |  | BELARUS | 14112289.62424239
BELARUS | 3159365.50303029 |  |  |  |  |  | BERMUDA |  |  | BERMUDA | 7056144.81212119
BELARUS | 10952924.1212121 |  |  |  |  |  | BOSNIA AND HERZEGOVINA |  |  | BOSNIA AND HERZEGOVINA | 13029850.92727268
BERMUDA | 7056144.81212119 |  |  |  |  |  | BULGARIA |  |  | BULGARIA | 11636630.3393939
BOSNIA AND HERZEGOVINA | 2509902.28484848 |  |  |  |  |  | CROATIA |  |  | CROATIA | 12813363.1878788
BOSNIA AND HERZEGOVINA | 10519948.6424242 |  |  |  |  |  | CYPRUS |  |  | CYPRUS | 15194728.32121207
BULGARIA | 34243 |  |  |  |  |  | CZECH REPUBLIC |  |  | CZECH REPUBLIC | 13029850.92727267
BULGARIA | 11602387.3393939 |  |  |  |  |  | ESTONIA |  |  | ESTONIA | 13679314.14545457
CROATIA | 2076926.8060606 |  |  |  |  |  | GEORGIA |  |  | GEORGIA | 13246338.66666662
CROATIA | 10736436.3818182 |  |  |  |  |  | GERMANY |  |  | GERMANY | 7489120.29090906
CYPRUS | 5973706.11515149 |  |  |  |  |  | GIBRALTAR |  |  | GIBRALTAR | 6406681.59393938
CYPRUS | 9221022.20606058 |  |  |  |  |  | HUNGARY |  |  | HUNGARY | 13554275.9939394
CZECH REPUBLIC | 5757218.37575755 |  |  |  |  |  | ISRAEL |  |  | ISRAEL | 13462826.40606057
CZECH REPUBLIC | 7272632.55151512 |  |  |  |  |  | KAZAKHSTAN |  |  | KAZAKHSTAN | 15675274.5575757
ESTONIA | 3592340.98181817 |  |  |  |  |  | LATVIA |  |  | LATVIA | 13728244.6
ESTONIA | 10086973.1636364 |  |  |  |  |  | LITHUANIA |  |  | LITHUANIA | 13462826.40606057
GEORGIA | 5324242.89696968 |  |  |  |  |  | MACEDONIA |  |  | MACEDONIA | 13679314.14545453
GEORGIA | 7922095.76969694 |  |  |  |  |  | MALTA |  |  | MALTA | 2726390.02424242
GERMANY | 7489120.29090906 |  |  |  |  |  | MOLDOVA |  |  | MOLDOVA | 13679314.1454545
GIBRALTAR | 6406681.59393938 |  |  |  |  |  | MONTENEGRO |  |  | MONTENEGRO | 3808828.72121211
HUNGARY | 3499 |  |  |  |  |  | NETHERLANDS |  |  | NETHERLANDS | 14112289.62424237
HUNGARY | 13550776.9939394 |  |  |  |  |  | POLAND |  |  | POLAND | 12728375.0363636
ISRAEL | 5107755.15757575 |  |  |  |  |  | ROMANIA |  |  | ROMANIA | 13000762.2969697
ISRAEL | 8355071.24848482 |  |  |  |  |  | RUSSIAN FEDERATION |  |  | RUSSIAN FEDERATION | 13141236.5151515
KAZAKHSTAN | 3423424 |  |  |  |  |  | SERBIA |  |  | SERBIA | 13462826.40606057
KAZAKHSTAN | 12251850.5575757 |  |  |  |  |  | SLOVAKIA |  |  | SLOVAKIA | 13679314.14545449
LATVIA | 2342345 |  |  |  |  |  | SLOVENIA |  |  | SLOVENIA | 12943615.7757576
LATVIA | 11385899.6 |  |  |  |  |  | TURKEY |  |  | TURKEY | 13566633.2545454
LITHUANIA | 4891267.4181818 |  |  |  |  |  | UKRAINE |  |  | UKRAINE | 11838875.0787879
LITHUANIA | 8571558.98787877 |  |  |  |  |  | UNITED KINGDOM |  |  | UNITED KINGDOM | 12813363.18787874
MACEDONIA | 3375853.24242423 |  |  |  |  |  | UZBEKISTAN |  |  | UZBEKISTAN | 14112289.62424245
MACEDONIA | 10303460.9030303 |  |  |  |  |  | Total |  |  | Grand Total | 430506006.6666657
MALTA | 2726390.02424242
MOLDOVA | 4674779.67878786
MOLDOVA | 9004534.46666664
MONTENEGRO | 3808828.72121211
NETHERLANDS | 4241804.19999999
NETHERLANDS | 9870485.42424238
POLAND | 43549
POLAND | 12684826.0363636
ROMANIA | 532424
ROMANIA | 12468338.2969697
RUSSIAN FEDERATION | 23435
RUSSIAN FEDERATION | 13117801.5151515
SERBIA | 4025316.46060605
SERBIA | 9437509.94545452
SLOVAKIA | 5540730.63636361
SLOVAKIA | 8138583.50909088
SLOVENIA | 42302
SLOVENIA | 12901313.7757576
TURKEY | 232344
TURKEY | 13334289.2545454
UKRAINE | 20000
UKRAINE | 11818875.0787879
UNITED KINGDOM | 6190193.85454543
UNITED KINGDOM | 6623169.33333331
UZBEKISTAN | 2942877.76363635
UZBEKISTAN | 11169411.8606061