Spreadsheet: 808663d1670575311-sumif-formula-countryexample
Sheet: Sheet4

store | order_finalisation_date | Destination Country | sales_before_discounts
SEU | 2022-12-07 00:00:00 | BE | 619.48
SEU | 2022-12-07 00:00:00 | BG | 452.33
SEU | 2022-12-07 00:00:00 | CI | 327.4
SEU | 2022-12-07 00:00:00 | CZ | 430.79
SEU | 2022-12-07 00:00:00 | DE | 3178.89
SEU | 2022-12-07 00:00:00 |  | 0
SEU | 2022-12-07 00:00:00 | ES | 193.86
SEU | 2022-12-07 00:00:00 | FI | 258.47
SEU | 2022-12-07 00:00:00 | FR | 1565.21
SEU | 2022-12-07 00:00:00 | GB | 272.84
SEU | 2022-12-07 00:00:00 |  | 0
SEU | 2022-12-07 00:00:00 | IE | 970.16
SEU | 2022-12-07 00:00:00 | IT | 660.55
SEU | 2022-12-07 00:00:00 | LT | 2355
SEU | 2022-12-07 00:00:00 | LU | 258.47
SEU | 2022-12-07 00:00:00 | LV | 129.24
SEU | 2022-12-07 00:00:00 | NL | 1217.6
SEU | 2022-12-07 00:00:00 | SE | 289.49
SEU | 2022-12-07 00:00:00 | US | 723.72
SUK | 2022-12-07 00:00:00 | AE | 4545
SUK | 2022-12-07 00:00:00 | AT | 315
SUK | 2022-12-07 00:00:00 | AU | 345
SUK | 2022-12-07 00:00:00 | BE | 315
SUK | 2022-12-07 00:00:00 | BR | 345
SUK | 2022-12-07 00:00:00 |  | 0
SUK | 2022-12-07 00:00:00 | CA | 1585
SUK | 2022-12-07 00:00:00 | CH | 1185
SUK | 2022-12-07 00:00:00 | CZ | 660
SUK | 2022-12-07 00:00:00 | DE | 945
SUK | 2022-12-07 00:00:00 | ES | 620
SUK | 2022-12-07 00:00:00 | FI | 315
SUK | 2022-12-07 00:00:00 | FR | 1225
SUK | 2022-12-07 00:00:00 | GB | 75580
SUK | 2022-12-07 00:00:00 | GI | 295
SUK | 2022-12-07 00:00:00 | GR | 345
SUK | 2022-12-07 00:00:00 |  | 0
SUK | 2022-12-07 00:00:00 | IE | 1085
SUK | 2022-12-07 00:00:00 | IT | 810
SUK | 2022-12-07 00:00:00 | JP | 495
SUK | 2022-12-07 00:00:00 | KW | 345
SUK | 2022-12-07 00:00:00 | LB | 1055
SUK | 2022-12-07 00:00:00 | LU | 820
SUK | 2022-12-07 00:00:00 | MX | 450
SUK | 2022-12-07 00:00:00 |  | 0
SUK | 2022-12-07 00:00:00 | NO | 1195
SUK | 2022-12-07 00:00:00 | PL | 310
SUK | 2022-12-07 00:00:00 | QA | 345
SUK | 2022-12-07 00:00:00 | SE | 990
SUK | 2022-12-07 00:00:00 | SG | 520
SUK | 2022-12-07 00:00:00 | US | 10725
SUS | 2022-12-07 00:00:00 | CA | 516.96
SUS | 2022-12-07 00:00:00 | DE | 396.33
SUS | 2022-12-07 00:00:00 | US | 47102.61
SEU | 2022-12-08 00:00:00 | BE | 619.48
SEU | 2022-12-08 00:00:00 | BG | 452.33
SEU | 2022-12-08 00:00:00 | CI | 327.4
SEU | 2022-12-08 00:00:00 | CZ | 430.79
SEU | 2022-12-08 00:00:00 | DE | 3178.89
SEU | 2022-12-08 00:00:00 |  | 0
SEU | 2022-12-08 00:00:00 | ES | 193.86
SEU | 2022-12-08 00:00:00 | FI | 258.47
SEU | 2022-12-08 00:00:00 | FR | 1565.21
SEU | 2022-12-08 00:00:00 | GB | 272.84
SEU | 2022-12-08 00:00:00 |  | 0
SEU | 2022-12-08 00:00:00 | IE | 970.16
SEU | 2022-12-08 00:00:00 | IT | 660.55
SEU | 2022-12-08 00:00:00 | LT | 2355
SEU | 2022-12-08 00:00:00 | LU | 258.47
SEU | 2022-12-08 00:00:00 | LV | 129.24
SEU | 2022-12-08 00:00:00 | NL | 1217.6
SEU | 2022-12-08 00:00:00 | SE | 289.49
SEU | 2022-12-08 00:00:00 | US | 723.72
SUK | 2022-12-08 00:00:00 | AE | 4545
SUK | 2022-12-08 00:00:00 | AT | 315
SUK | 2022-12-08 00:00:00 | AU | 345
SUK | 2022-12-08 00:00:00 | BE | 315
SUK | 2022-12-08 00:00:00 | BR | 345
SUK | 2022-12-08 00:00:00 |  | 0
SUK | 2022-12-08 00:00:00 | CA | 1585
SUK | 2022-12-08 00:00:00 | CH | 1185
SUK | 2022-12-08 00:00:00 | CZ | 660
SUK | 2022-12-08 00:00:00 | DE | 945
SUK | 2022-12-08 00:00:00 | ES | 620
SUK | 2022-12-08 00:00:00 | FI | 315
SUK | 2022-12-08 00:00:00 | FR | 1225
SUK | 2022-12-08 00:00:00 | GB | 75580
SUK | 2022-12-08 00:00:00 | GI | 295
SUK | 2022-12-08 00:00:00 | GR | 345
SUK | 2022-12-08 00:00:00 |  | 0
SUK | 2022-12-08 00:00:00 | IE | 1085
SUK | 2022-12-08 00:00:00 | IT | 810
SUK | 2022-12-08 00:00:00 | JP | 495
SUK | 2022-12-08 00:00:00 | KW | 345
SUK | 2022-12-08 00:00:00 | LB | 1055
SUK | 2022-12-08 00:00:00 | LU | 820
SUK | 2022-12-08 00:00:00 | MX | 450
SUK | 2022-12-08 00:00:00 |  | 0
SUK | 2022-12-08 00:00:00 | NO | 1195
SUK | 2022-12-08 00:00:00 | PL | 310
SUK | 2022-12-08 00:00:00 | QA | 345
SUK | 2022-12-08 00:00:00 | SE | 990
SUK | 2022-12-08 00:00:00 | SG | 520
SUK | 2022-12-08 00:00:00 | US | 10725
SUS | 2022-12-08 00:00:00 | CA | 516.96
SUS | 2022-12-08 00:00:00 | DE | 396.33
SUS | 2022-12-08 00:00:00 | US | 47102.61
SEU | 2022-12-01 00:00:00 | BE | 619.48
SEU | 2022-12-01 00:00:00 | BG | 452.33
SEU | 2022-12-01 00:00:00 | CI | 327.4
SEU | 2022-12-01 00:00:00 | CZ | 430.79
SEU | 2022-12-01 00:00:00 | DE | 3178.89
SEU | 2022-12-01 00:00:00 |  | 0
SEU | 2022-12-01 00:00:00 | ES | 193.86
SEU | 2022-12-01 00:00:00 | FI | 258.47
SEU | 2022-12-01 00:00:00 | FR | 1565.21
SEU | 2022-12-01 00:00:00 | GB | 272.84
SEU | 2022-12-01 00:00:00 |  | 0
SEU | 2022-12-01 00:00:00 | IE | 970.16
SEU | 2022-12-01 00:00:00 | IT | 660.55
SEU | 2022-12-01 00:00:00 | LT | 2355
SEU | 2022-12-01 00:00:00 | LU | 258.47
SEU | 2022-12-01 00:00:00 | LV | 129.24
SEU | 2022-12-01 00:00:00 | NL | 1217.6
SEU | 2022-12-01 00:00:00 | SE | 289.49
SEU | 2022-12-01 00:00:00 | US | 723.72
SUK | 2022-12-01 00:00:00 | AE | 4545
SUK | 2022-12-01 00:00:00 | AT | 315
SUK | 2022-12-01 00:00:00 | AU | 345
SUK | 2022-12-01 00:00:00 | BE | 315
SUK | 2022-12-01 00:00:00 | BR | 345
SUK | 2022-12-01 00:00:00 |  | 0
SUK | 2022-12-01 00:00:00 | CA | 1585
SUK | 2022-12-01 00:00:00 | CH | 1185
SUK | 2022-12-01 00:00:00 | CZ | 660
SUK | 2022-12-01 00:00:00 | DE | 945
SUK | 2022-12-01 00:00:00 | ES | 620
SUK | 2022-12-01 00:00:00 | FI | 315
SUK | 2022-12-01 00:00:00 | FR | 1225
SUK | 2022-12-01 00:00:00 | GB | 75580
SUK | 2022-12-01 00:00:00 | GI | 295
SUK | 2022-12-01 00:00:00 | GR | 345
SUK | 2022-12-01 00:00:00 |  | 0
SUK | 2022-12-01 00:00:00 | IE | 1085
SUK | 2022-12-01 00:00:00 | IT | 810
SUK | 2022-12-01 00:00:00 | JP | 495
SUK | 2022-12-01 00:00:00 | KW | 345
SUK | 2022-12-01 00:00:00 | LB | 1055
SUK | 2022-12-01 00:00:00 | LU | 820
SUK | 2022-12-01 00:00:00 | MX | 450
SUK | 2022-12-01 00:00:00 |  | 0
SUK | 2022-12-01 00:00:00 | NO | 1195
SUK | 2022-12-01 00:00:00 | PL | 310
SUK | 2022-12-01 00:00:00 | QA | 345
SUK | 2022-12-01 00:00:00 | SE | 990
SUK | 2022-12-01 00:00:00 | SG | 520
SUK | 2022-12-01 00:00:00 | US | 10725
SUS | 2022-12-01 00:00:00 | CA | 516.96
SUS | 2022-12-01 00:00:00 | DE | 396.33
SUS | 2022-12-01 00:00:00 | US | 47102.61