Spreadsheet: 377809d1424175887-l-sung-ber-formel-oder-vba-test-2-
Sheet: Tabelle1

 | Abwesenheit Zeit [h] | Abwesenheit Land |  |  | [NAME] |  |  |  |  |  | Auslösung Betrag [EURO]
 | 8.5 | Spanien |  |  | Land | Länderkürzel | Stunden | [NAME] | Steuerfrei
 |  |  |  |  |  |  |  |  |  |  |  |  | dummy1 | dummy2
 |  |  |  |  | Deutschland | D | bis 6 [NAME]. | <6 | 0 |  |  |  | Deutschland | 0
 |  |  |  |  |  |  | 6-8 Std. | <8 | 0 |  |  |  | Deutschland | 6
 |  |  |  |  |  |  | 8-10 Std. | <10 | 12 |  |  |  | Deutschland | 8
 |  |  |  |  |  |  | 10-24 Std. | <24 | 12 |  |  |  | Deutschland | 10
 |  |  |  |  |  |  | 24 [NAME]. | 24 | 24 |  |  |  | Deutschland | 24
 |  |  |  |  | Belgien | BE | bis 8 Std. | <8 | 0 |  |  |  | Belgien | 0
 |  |  |  |  |  |  | 8-24 Std. | <24 | 27 |  |  |  | Belgien | 8
 |  |  |  |  |  |  | 24 [NAME]. | 24 | 40 |  |  |  | Belgien | 24
 |  |  |  |  | [NAME] | CH | bis 8 Std. | <8 | 0 |  |  |  | [NAME] | 0
 |  |  |  |  |  |  | 8-24 Std. | <24 | 32 |  |  |  | [NAME] | 8
 |  |  |  |  |  |  | 24 [NAME]. | 24 | 48 |  |  |  | [NAME] | 24
 |  |  |  |  | Italien | I | bis 8 Std. | <8 | 0 |  |  |  | Italien | 0
 |  |  |  |  |  |  | 8-24 Std. | <24 | 23 |  |  |  | Italien | 8
 |  |  |  |  |  |  | 24 [NAME]. | 24 | 34 |  |  |  | Italien | 24
 |  |  |  |  | Frankreich | F | bis 8 Std. | <8 | 0 |  |  |  | Frankreich | 0
 |  |  |  |  |  |  | 8-24 Std. | <24 | 29 |  |  |  | Frankreich | 8
 |  |  |  |  |  |  | 24 [NAME]. | 24 | 44 |  |  |  | Frankreich | 24
 |  |  |  |  | Niederlande | NL | bis 8 Std. | <8 | 0 |  |  |  | Niederlande | 0
 |  |  |  |  |  |  | 8-24 Std. | <24 | 31 |  |  |  | Niederlande | 8
 |  |  |  |  |  |  | 24 [NAME]. | 24 | 46 |  |  |  | Niederlande | 24
 |  |  |  |  | Österreich | A | bis 8 Std. | <8 | 0 |  |  |  | Österreich | 0
 |  |  |  |  |  |  | 8-24 Std. | <24 | 24 |  |  |  | Österreich | 8
 |  |  |  |  |  |  | 24 [NAME]. | 24 | 36 |  |  |  | Österreich | 24
 |  |  |  |  | [NAME] | PO | bis 8 Std. | <8 | 0 |  |  |  | [NAME] | 0
 |  |  |  |  |  |  | 8-24 Std. | <24 | 18 |  |  |  | [NAME] | 8
 |  |  |  |  |  |  | 24 [NAME]. | 24 | 27 |  |  |  | [NAME] | 24
 |  |  |  |  | Türkei | T | bis 8 Std. | <=8 | 0 |  |  |  | Türkei | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 27 |  |  |  | Türkei | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 40 |  |  |  | Türkei | 24
 |  |  |  |  | Spanien | E | bis 8 Std. | <=8 | 0 |  |  |  | Spanien | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 20 |  |  |  | Spanien | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 29 |  |  |  | Spanien | 24
 |  |  |  |  | Portugal | P | bis 8 Std. | <=8 | 0 |  |  |  | Portugal | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 24 |  |  |  | Portugal | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 36 |  |  |  | Portugal | 24
 |  |  |  |  | [NAME] | DA | bis 8 Std. | <=8 | 0 |  |  |  | [NAME] | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 40 |  |  |  | [NAME] | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 51 |  |  |  | [NAME] | 24
 |  |  |  |  | [NAME] | RO | bis 8 Std. | <=8 | 0 |  |  |  | [NAME] | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 18 |  |  |  | [NAME] | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 27 |  |  |  | [NAME] | 24
 |  |  |  |  | Schweden | SCH | bis 8 Std. | <=8 | 0 |  |  |  | Schweden | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 48 |  |  |  | Schweden | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 51 |  |  |  | Schweden | 24
 |  |  |  |  | Slowakei | SL | bis 8 Std. | <=8 | 0 |  |  |  | Slowakei | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 16 |  |  |  | Slowakei | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 24 |  |  |  | Slowakei | 24
 |  |  |  |  | Tschechien | CZ | bis 8 Std. | <=8 | 0 |  |  |  | Tschechien | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 16 |  |  |  | Tschechien | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 24 |  |  |  | Tschechien | 24
 |  |  |  |  | Ungarn | U | bis 8 Std. | <=8 | 0 |  |  |  | Ungarn | 0
 |  |  |  |  |  |  | 8-24 Std. | >8 <24 | 20 |  |  |  | Ungarn | 8.001
 |  |  |  |  |  |  | 24 [NAME]. | =24 | 30 |  |  |  | Ungarn | 24