meldarionqeusse
9/1/2016 - 1:19 PM
Search word in range of cells and copy the value in a range new cell
={SUM(IF(F2:F21=K1,G2:G21,0))}
Total Home Goals Total Away Goals Total Games Played Home Total Games Played Away Power Home Power Away Defensive Home Defensive Away atalanta juventus
Atalanta 22 16 19 19 Atalanta 1.158 0.842 1 1 Goals 0 1 2 3 4 5 6 7 8 9
Cagliari 24 24 19 19 Cagliari 1.263 1.263 1 1 0 0.076 0.108 0.077 0.036 0.013 0.004 0.001 0.000 0.000 0.000
Cesena 19 17 19 19 Cesena 1.000 0.895 1 1 1 0.088 0.125 0.089 0.042 0.015 0.004 0.001 0.000 0.000 0.000
Chievo 16 12 19 19 Chievo 0.842 0.632 1 1 2 0.051 0.072 0.051 0.024 0.009 0.002 0.001 0.000 0.000 0.000
Empoli 26 20 19 19 Empoli 1.368 1.053 1 1 3 0.020 0.028 0.020 0.009 0.003 0.001 0.000 0.000 0.000 0.000
Fiorentina 30 31 19 19 Fiorentina 1.579 1.632 1 1 4 0.006 0.008 0.006 0.003 0.001 0.000 0.000 0.000 0.000 0.000
Genoa 33 29 19 19 Genoa 1.737 1.526 1 1 5 0.001 0.002 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000
Inter 33 26 19 19 Inter 1.737 1.368 1 1 6 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Juventus 45 27 19 19 Juventus 2.368 1.421 1 1 7 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Lazio 40 31 19 19 Lazio 2.105 1.632 1 1 8 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Milan 30 26 19 19 Milan 1.579 1.368 1 1 9 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Napoli 46 24 19 19 Napoli 2.421 1.263 1 1
Palermo 30 23 19 19 Palermo 1.579 1.211 1 1 Exponent 2.718
Parma 19 14 19 19 Parma 1.000 0.737 1 1 LambdaHometeam 1.158 LambdaAway Team 1.421
Roma 31 23 19 19 Roma 1.632 1.211 1 1
Sampdoria 23 25 19 19 Sampdoria 1.211 1.316 1 1 HomeTeam AwayTeam
Sassuolo 25 24 19 19 Sassuolo 1.316 1.263 1 1 Goals
Torino 25 23 19 19 Torino 1.316 1.211 1 1 0 0.314 0.241
Udinese 26 17 19 19 Udinese 1.368 0.895 1 1 1 0.364 0.343
Verona 27 22 19 19 Verona 1.421 1.158 1 1 2 0.211 0.244
3 0.081 0.116
4 0.024 0.041
5 0.005 0.012
6 0.001 0.003
7 0.000 0.001
8 0.000 0.000
9 0.000 0.000
={SUM(IF(F2:F21=K1,G2:G21,0))}