But if you insist on formulas...
Attach headers to your data as shown
Days Name1 Type1
5 Ke Comp
0.5 Ke Safe
3 Su Comp
2 Pe Mgm
1 Pe Safe

Comp Safe Mgm Type2
Ke 5 0.5 0
Su 3 0 0
Pe 0 1 2
Name2

Insert Name Create Days, Name1, Type1 in the first array
and Name2, Type2 in the second array
The formula in R1C1 format is
=SUMPRODUCT((Type1=Type2 C)*(Name1=Name2 R)*Days)