Spreadsheet: 727099d1617714981-count-formular-with-multiple-conditions-test-excel-forum
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  | 1 | Zone 1 | Zip code from | Zip code to | Jan | Feb | Mar | Apr | Maj | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  |  |  |  |  |  |  |  |  | 2 | Sjælland 1000 - 3700 | >=1000 | <=3700 | =COUNTIFS(Leveringer!$AK$1094:$AK$2227;$M$39;Leveringer!$AK$1094:$AK$2227;$N$39) | 149 | 170 | 125 | 132 | 171 | 134 | 148 | 178 | 209 | 151 | 91
 |  |  |  |  |  |  |  |  |  | 3 | Sjælland 4000 - 4799 | >=4000 | <=4799 |  | 4 | 4 | 8 | 3 | 21 | 24 | 16 | 16 | 22 | 11 | 4
 |  |  |  |  |  |  |  |  |  | 4 | Total Sjælland / Bornholm |  |  | 212 | 153 | 174 | 133 | 135 | 192 | 158 | 164 | 194 | 231 | 162 | 95
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  | 6 | Zone 2
 |  |  |  |  |  |  |  |  |  | 7 | Lolland / Falster 4800 - 4999 | >=4800 | <=4999 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 2 | 3 | 1 | 0
 |  |  |  |  |  |  |  |  |  | 8 | Total Lolland / Falster |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 2 | 3 | 1 | 0
 |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  | 10 | Zone 3
 |  |  |  |  |  |  |  |  |  | 11 | Fyn 5000 - 5999 | >=5000 | <=5999 | 21 | 13 | 23 | 11 | 9 | 6 | 8 | 12 | 4 | 6 | 6 | 6
 |  |  |  |  |  |  |  |  |  | 12 | Total Fyn |  |  | 21 | 13 | 23 | 11 | 9 | 6 | 8 | 12 | 4 | 6 | 6 | 6
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 14 | Zone 4
 |  |  |  |  |  |  |  |  |  | 15 | SønderJylland 6000 - 6799 | >=6000 | <=6799 | 15 | 15 | 7 | 9 | 7 | 7 | 7 | 18 | 19 | 36 | 19 | 7
 |  |  |  |  |  |  |  |  |  | 16 | Total SønderJylland |  |  | 15 | 15 | 7 | 9 | 7 | 7 | 7 | 18 | 19 | 36 | 19 | 7
 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  | 18 | Zone 5
 |  |  |  |  |  |  |  |  |  | 19 | MidtJylland 6800 - 7620 | >=6800 | <=7620 | 16 | 14 | 6 | 7 | 5 | 3 | 6 | 8 | 5 | 3 | 2 | 4
 |  |  |  |  |  |  |  |  |  | 20 | MidtJylland 8000 - 8999 | >=8000 | <=8999 | 47 | 25 | 32 | 17 | 19 | 27 | 47 | 45 | 29 | 32 | 29 | 5
 |  |  |  |  |  |  |  |  |  | 21 | Total MidtJylland |  |  | 63 | 39 | 38 | 24 | 24 | 30 | 53 | 53 | 34 | 35 | 31 | 9
 |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  | 23 | Zone 6
 |  |  |  |  |  |  |  |  |  | 24 | NordJylland 7621 - 7999 | >=7621 | <=7999 | 0 | 0 | 1 | 3 | 7 | 5 | 5 | 2 | 3 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 25 | NordJylland 9000 - 9999 | >=9000 | <=9999 | 26 | 17 | 21 | 24 | 13 | 15 | 12 | 14 | 13 | 15 | 10 | 2
 |  |  |  |  |  |  |  |  |  | 26 | Total NordJylland |  |  | 26 | 17 | 22 | 27 | 20 | 20 | 17 | 16 | 16 | 17 | 10 | 2
 |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  | 28 | Total totalt |  |  | 337 | 237 | 264 | 204 | 195 | 256 | 246 | 267 | 269 | 328 | 229 | 119
 |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  | 30 | International | PERI* |  | =COUNTIF(Leveringer!$G$1094:$G$2227;$M$38) | 55 | 49 | 27 | 34 | 45 | 34 | 43 | 69 | 64 | 41 | 29
 |  |  |  |  |  |  |  |  |  | 31 | Færøerne | >=100 | <=999 | =COUNTIFS(Leveringer!$AK$1094:$AK$2227;$M$39;Leveringer!$AK$1094:$AK$2227;$N$39) | 1 | 0 | 0 | 5 | 1 | 0 | 0 | 3 | 3 | 2 | 0
 |  |  |  |  |  |  |  |  |  | 32 | Grønland | >=3900 | <=3999 | =COUNTIFS(Leveringer!$AK$1094:$AK$2227;$M$40;Leveringer!$AK$1094:$AK$2227;$N$40) | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34 |  |  |  | Jan | Feb | Mar | Apr | Maj | Jun | Jul | Aug | Sep | Okt | Nov | Dec
 |  |  |  |  |  |  |  |  |  | 35 | Kundens fragt pris (KP) |  |  | =SUM(Leveringer!$AL$1094:$AL$2227) | 694880 | 418590 | 412295 | 331552.24 | 425193.5 | 418590 | 412295 | 331552.24 | 425193.5 | 410254.5 | 412295
 |  |  |  |  |  |  |  |  |  | 36 | Peri´s fragt pris (LP) |  |  | =SUM(Leveringer!$AM$1094:$AM$2227) | 691526 | 428919 | 391987 | 327961.49 | 432770 | 428919 | 391987 | 327961.49 | 432770 | 400741.5 | 391987
 |  |  |  |  |  |  |  |  |  | 37 | [NAME] | FRANKO |  | =COUNTIF(Leveringer!$R$1094:$R$2227;$M$45) | 11 | 12 | 6 | 16 | 6 | 2 | 18 | 5 | 5 | 3 | 3
 |  |  |  |  |  |  |  |  |  | 38 | Franko PERI´s PRIS |  |  | =SUMIF(Leveringer!$R$1094:$R$2227; "FRANKO"; Leveringer!$S$1094:$S$2227) | 12550 | 18512 | 6134 | 22785 | 8650 | 3350 | 29575 | 7971 | 11100 | 3350 | 4894