ich brauche nochmal eure Hilfe zu dieser Excel Datei :
https://www.herber.de/bbs/user/90408.xlsx
Ich möchte gerne, wie in der Datei beschrieben, dass ich die prozentualen Anteile von NUTZ pro GRIDCODE sehen kann.
Danke schonmal.
A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | GRIDCODE | NUTZ | flaeche_km2 | GRIDCODE | flache_ges km2 pro GRIDCODE | NUTZ | 11 | 21 | 22 | 23 | 31 | SONSTIGE NUTZ (13,22,32,33,41,42,43,51,52) | |
2 | 6 | 21 | 0,05121 | 6 | 0,07643 | 0 | 67,00248593 | 0 | 0 | 31,38819835 | 1,609315714 | ||
3 | 6 | 31 | 0,02399 | 7 | 0,0016 | 0 | 0 | 0 | 0 | 100 | 0 | ||
4 | 6 | 13 | 0,00123 | 10 | 0,0752 | 0 | 0 | 0 | 0 | 100 | 0 | ||
5 | 7 | 31 | 0,00160 | 19 | 23,21601 | 0 | 29,53802139 | 0 | 6 | 64,07474842 | 0 | ||
6 | 10 | 31 | 0,00864 | 20 | 0,0032 | 0 | 100 | 0 | 0 | 0 | 0 | ||
7 | 10 | 31 | 0,06656 | 22 | 3,0864 | 0 | 0 | 0 | 0 | 100 | 0 | ||
8 | 19 | 23 | 1,48286 | ||||||||||
9 | 19 | 31 | 3,72745 | ||||||||||
10 | 19 | 31 | 3,57449 | ||||||||||
11 | 19 | 21 | 0,94368 | ||||||||||
12 | 19 | 31 | 7,57366 | ||||||||||
13 | 19 | 21 | 5,91387 | ||||||||||
14 | 20 | 21 | 0,00320 | ||||||||||
15 | 22 | 31 | 2,99360 | ||||||||||
16 | 22 | 31 | 0,09280 |
Zelle | Formel |
F2 | =SUMMEWENN(A:A;E2;C:C) |
H2 | =SUMMEWENNS($C:$C;$A:$A;$E2;$B:$B;H$1)/$F2% |
I2 | =SUMMEWENNS($C:$C;$A:$A;$E2;$B:$B;I$1)/$F2% |
J2 | =SUMMEWENNS($C:$C;$A:$A;$E2;$B:$B;J$1)/$F2% |
K2 | =SUMMEWENNS($C:$C;$A:$A;$E2;$B:$B;K$1)/$F2% |
L2 | =SUMMEWENNS($C:$C;$A:$A;$E2;$B:$B;L$1)/$F2% |
M2 | =100-SUMME(H2:L2) |