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

RAW | order_finalisation_date | Destination Country | sales_before_discounts |  | Sum between |  | Destination Country |  |  | sales_before_discounts
 | 2022-12-07 00:00:00 | BE | 619.48 |  | 2022-12-07 00:00:00 | 2022-12-08 00:00:00 | BE |  | This is the combined total for all the countries listed in column H | 339368.8
 | 2022-12-07 00:00:00 | BG | 452.33 |  |  |  | BG |  | Total is between 07/12 - 08/12
 | 2022-12-07 00:00:00 | CI | 327.4 |  |  |  | CI
 | 2022-12-07 00:00:00 | CZ | 430.79 |  |  |  | CZ
 | 2022-12-07 00:00:00 | DE | 3178.89 |  |  |  | DE
 | 2022-12-07 00:00:00 |  | 0 |  |  |  | ES
 | 2022-12-07 00:00:00 | ES | 193.86 |  |  |  | FI
 | 2022-12-07 00:00:00 | FI | 258.47 |  |  |  | FR
 | 2022-12-07 00:00:00 | FR | 1565.21 |  |  |  | GB
 | 2022-12-07 00:00:00 | GB | 272.84 |  |  |  | IE
 | 2022-12-07 00:00:00 |  | 0 |  |  |  | IT
 | 2022-12-07 00:00:00 | IE | 970.16 |  |  |  | LT
 | 2022-12-07 00:00:00 | IT | 660.55 |  |  |  | LU
 | 2022-12-07 00:00:00 | LT | 2355 |  |  |  | LV
 | 2022-12-07 00:00:00 | LU | 258.47 |  |  |  | NL
 | 2022-12-07 00:00:00 | LV | 129.24 |  |  |  | SE
 | 2022-12-07 00:00:00 | NL | 1217.6 |  |  |  | US
 | 2022-12-07 00:00:00 | SE | 289.49 |  |  |  | AE
 | 2022-12-07 00:00:00 | US | 723.72 |  |  |  | AT
 | 2022-12-07 00:00:00 | AE | 4545 |  |  |  | AU
 | 2022-12-07 00:00:00 | AT | 315 |  |  |  | BR
 | 2022-12-07 00:00:00 | AU | 345
 | 2022-12-07 00:00:00 | BE | 315
 | 2022-12-07 00:00:00 | BR | 345
 | 2022-12-07 00:00:00 |  | 0
 | 2022-12-07 00:00:00 | CA | 1585
 | 2022-12-07 00:00:00 | CH | 1185
 | 2022-12-07 00:00:00 | CZ | 660
 | 2022-12-07 00:00:00 | DE | 945
 | 2022-12-07 00:00:00 | ES | 620
 | 2022-12-07 00:00:00 | FI | 315
 | 2022-12-07 00:00:00 | FR | 1225
 | 2022-12-07 00:00:00 | GB | 75580
 | 2022-12-07 00:00:00 | GI | 295
 | 2022-12-07 00:00:00 | GR | 345
 | 2022-12-07 00:00:00 |  | 0
 | 2022-12-07 00:00:00 | IE | 1085
 | 2022-12-07 00:00:00 | IT | 810
 | 2022-12-07 00:00:00 | JP | 495
 | 2022-12-07 00:00:00 | KW | 345
 | 2022-12-07 00:00:00 | LB | 1055
 | 2022-12-07 00:00:00 | LU | 820
 | 2022-12-07 00:00:00 | MX | 450
 | 2022-12-07 00:00:00 |  | 0
 | 2022-12-07 00:00:00 | NO | 1195
 | 2022-12-07 00:00:00 | PL | 310
 | 2022-12-07 00:00:00 | QA | 345
 | 2022-12-07 00:00:00 | SE | 990
 | 2022-12-07 00:00:00 | SG | 520
 | 2022-12-07 00:00:00 | US | 10725
 | 2022-12-07 00:00:00 | CA | 516.96
 | 2022-12-07 00:00:00 | DE | 396.33
 | 2022-12-07 00:00:00 | US | 47102.61
 | 2022-12-08 00:00:00 | BE | 619.48
 | 2022-12-08 00:00:00 | BG | 452.33
 | 2022-12-08 00:00:00 | CI | 327.4
 | 2022-12-08 00:00:00 | CZ | 430.79
 | 2022-12-08 00:00:00 | DE | 3178.89
 | 2022-12-08 00:00:00 |  | 0
 | 2022-12-08 00:00:00 | ES | 193.86
 | 2022-12-08 00:00:00 | FI | 258.47
 | 2022-12-08 00:00:00 | FR | 1565.21
 | 2022-12-08 00:00:00 | GB | 272.84
 | 2022-12-08 00:00:00 |  | 0
 | 2022-12-08 00:00:00 | IE | 970.16
 | 2022-12-08 00:00:00 | IT | 660.55
 | 2022-12-08 00:00:00 | LT | 2355
 | 2022-12-08 00:00:00 | LU | 258.47
 | 2022-12-08 00:00:00 | LV | 129.24
 | 2022-12-08 00:00:00 | NL | 1217.6
 | 2022-12-08 00:00:00 | SE | 289.49
 | 2022-12-08 00:00:00 | US | 723.72
 | 2022-12-08 00:00:00 | AE | 4545
 | 2022-12-08 00:00:00 | AT | 315
 | 2022-12-08 00:00:00 | AU | 345
 | 2022-12-08 00:00:00 | BE | 315
 | 2022-12-08 00:00:00 | BR | 345
 | 2022-12-08 00:00:00 |  | 0
 | 2022-12-08 00:00:00 | CA | 1585
 | 2022-12-08 00:00:00 | CH | 1185
 | 2022-12-08 00:00:00 | CZ | 660
 | 2022-12-08 00:00:00 | DE | 945
 | 2022-12-08 00:00:00 | ES | 620
 | 2022-12-08 00:00:00 | FI | 315
 | 2022-12-08 00:00:00 | FR | 1225
 | 2022-12-08 00:00:00 | GB | 75580
 | 2022-12-08 00:00:00 | GI | 295
 | 2022-12-08 00:00:00 | GR | 345
 | 2022-12-08 00:00:00 |  | 0
 | 2022-12-08 00:00:00 | IE | 1085
 | 2022-12-08 00:00:00 | IT | 810
 | 2022-12-08 00:00:00 | JP | 495
 | 2022-12-08 00:00:00 | KW | 345
 | 2022-12-08 00:00:00 | LB | 1055
 | 2022-12-08 00:00:00 | LU | 820
 | 2022-12-08 00:00:00 | MX | 450
 | 2022-12-08 00:00:00 |  | 0
 | 2022-12-08 00:00:00 | NO | 1195
 | 2022-12-08 00:00:00 | PL | 310
 | 2022-12-08 00:00:00 | QA | 345
 | 2022-12-08 00:00:00 | SE | 990
 | 2022-12-08 00:00:00 | SG | 520
 | 2022-12-08 00:00:00 | US | 10725
 | 2022-12-08 00:00:00 | CA | 516.96
 | 2022-12-08 00:00:00 | DE | 396.33
 | 2022-12-08 00:00:00 | US | 47102.61
 | 2022-12-01 00:00:00 | BE | 619.48
 | 2022-12-01 00:00:00 | BG | 452.33
 | 2022-12-01 00:00:00 | CI | 327.4
 | 2022-12-01 00:00:00 | CZ | 430.79
 | 2022-12-01 00:00:00 | DE | 3178.89
 | 2022-12-01 00:00:00 |  | 0
 | 2022-12-01 00:00:00 | ES | 193.86
 | 2022-12-01 00:00:00 | FI | 258.47
 | 2022-12-01 00:00:00 | FR | 1565.21
 | 2022-12-01 00:00:00 | GB | 272.84
 | 2022-12-01 00:00:00 |  | 0
 | 2022-12-01 00:00:00 | IE | 970.16
 | 2022-12-01 00:00:00 | IT | 660.55
 | 2022-12-01 00:00:00 | LT | 2355
 | 2022-12-01 00:00:00 | LU | 258.47
 | 2022-12-01 00:00:00 | LV | 129.24
 | 2022-12-01 00:00:00 | NL | 1217.6
 | 2022-12-01 00:00:00 | SE | 289.49
 | 2022-12-01 00:00:00 | US | 723.72
 | 2022-12-01 00:00:00 | AE | 4545
 | 2022-12-01 00:00:00 | AT | 315
 | 2022-12-01 00:00:00 | AU | 345
 | 2022-12-01 00:00:00 | BE | 315
 | 2022-12-01 00:00:00 | BR | 345
 | 2022-12-01 00:00:00 |  | 0
 | 2022-12-01 00:00:00 | CA | 1585
 | 2022-12-01 00:00:00 | CH | 1185
 | 2022-12-01 00:00:00 | CZ | 660
 | 2022-12-01 00:00:00 | DE | 945
 | 2022-12-01 00:00:00 | ES | 620
 | 2022-12-01 00:00:00 | FI | 315
 | 2022-12-01 00:00:00 | FR | 1225
 | 2022-12-01 00:00:00 | GB | 75580
 | 2022-12-01 00:00:00 | GI | 295
 | 2022-12-01 00:00:00 | GR | 345
 | 2022-12-01 00:00:00 |  | 0
 | 2022-12-01 00:00:00 | IE | 1085
 | 2022-12-01 00:00:00 | IT | 810
 | 2022-12-01 00:00:00 | JP | 495
 | 2022-12-01 00:00:00 | KW | 345
 | 2022-12-01 00:00:00 | LB | 1055
 | 2022-12-01 00:00:00 | LU | 820
 | 2022-12-01 00:00:00 | MX | 450
 | 2022-12-01 00:00:00 |  | 0
 | 2022-12-01 00:00:00 | NO | 1195
 | 2022-12-01 00:00:00 | PL | 310
 | 2022-12-01 00:00:00 | QA | 345
 | 2022-12-01 00:00:00 | SE | 990
 | 2022-12-01 00:00:00 | SG | 520
 | 2022-12-01 00:00:00 | US | 10725
 | 2022-12-01 00:00:00 | CA | 516.96
 | 2022-12-01 00:00:00 | DE | 396.33
 | 2022-12-01 00:00:00 | US | 47102.61
 | 2022-12-07 00:00:00 | UK | 516.96
 | 2022-12-08 00:00:00 | UK | 10000
 | 2022-12-09 00:00:00 | UK | 12000