Just guessing,

Row\Col
A
B
C
D
E
F
G
H
I
2
 RE:
10
20
30
40
50
3
 Colleague 1
7.00
140
100.00%
 H3: =SUMPRODUCT(C3:G3/C$2:G$2)/B3
4
 Colleague 2
7.00
2
2.86%