- | A | B | C | D | E |
---|
1 | Top | wie oft in diesen Jahr | gesamt Betrag | Artikel | Bezeichnung |
2 | 1 | =ZÄHLENWENN($B$14:$B$999;D2) | =KKLEINSTE($E$14:$E$999;A2) | =XVERWEIS(C2;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C2;$E$14:$E$999;$C$14:$C$999) |
3 | 2 | =ZÄHLENWENN($B$14:$B$999;D3) | =KKLEINSTE($E$14:$E$999;A3) | =XVERWEIS(C3;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C3;$E$14:$E$999;$C$14:$C$999) |
4 | 3 | =ZÄHLENWENN($B$14:$B$999;D4) | =KKLEINSTE($E$14:$E$999;A4) | =XVERWEIS(C4;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C4;$E$14:$E$999;$C$14:$C$999) |
5 | 4 | =ZÄHLENWENN($B$14:$B$999;D5) | =KKLEINSTE($E$14:$E$999;A5) | =XVERWEIS(C5;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C5;$E$14:$E$999;$C$14:$C$999) |
6 | 5 | =ZÄHLENWENN($B$14:$B$999;D6) | =KKLEINSTE($E$14:$E$999;A6) | =XVERWEIS(C6;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C6;$E$14:$E$999;$C$14:$C$999) |
7 | 6 | =ZÄHLENWENN($B$14:$B$999;D7) | =KKLEINSTE($E$14:$E$999;A7) | =XVERWEIS(C7;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C7;$E$14:$E$999;$C$14:$C$999) |
8 | 7 | =ZÄHLENWENN($B$14:$B$999;D8) | =KKLEINSTE($E$14:$E$999;A8) | =XVERWEIS(C8;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C8;$E$14:$E$999;$C$14:$C$999) |
9 | 8 | =ZÄHLENWENN($B$14:$B$999;D9) | =KKLEINSTE($E$14:$E$999;A9) | =XVERWEIS(C9;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C9;$E$14:$E$999;$C$14:$C$999) |
10 | 9 | =ZÄHLENWENN($B$14:$B$999;D10) | =KKLEINSTE($E$14:$E$999;A10) | =XVERWEIS(C10;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C10;$E$14:$E$999;$C$14:$C$999) |
11 | 10 | =ZÄHLENWENN($B$14:$B$999;D11) | =KKLEINSTE($E$14:$E$999;A11) | =XVERWEIS(C11;$E$14:$E$999;$B$14:$B$999) | =XVERWEIS(C11;$E$14:$E$999;$C$14:$C$999) |
12 | | | | | |
13 | | Artikel | | | |
14 | | 118977 | HACKF | -11272,44 | =WENN(SUMME(--($B$14:B14=B14))=1;SUMMEWENN($B$14:$B$999;B14;$D$14:$D$999);0) |
15 | | 104117 | SW KA | -9780,4 | =WENN(SUMME(--($B$14:B15=B15))=1;SUMMEWENN($B$14:$B$999;B15;$D$14:$D$999);0) |