A
B
C
D
1
Data
nr. Crt
x%
2
 16.11.2013
17
100%
3
 16.11.2013
1
50%
4
 17.11.2013
1
50%
5
 17.11.2013
5
100%
6
 18.11.2013
3
100%
7
 18.11.2013
1
50%
8
9
 Amt
10
50%
1
 B10: =MOD(SUMPRODUCT(B2:B7,C2:C7),1)/A10
11
100%
26
 B11: =INT(SUMPRODUCT(B2:B7, C2:C7))