Formula for different averages in a table

[Brutor]

Hello MrExcel experts!

I have been working on my bachelor's thesis for a while (I'm investigating whether or not there is a home advantage in Formula One) and ran into some problems earlier today.
Below I have posted the 2016 season, with all cells filled in by hand (numbers are final position in the race). My question concerns the columns in bold, at the end of the table.
Right now all the values are entered by hand, but I am looking for three formulas that can save me a great deal of time, since I have about fifty more seasons to go.
About the coding: The R stands for Race (I use a similar table for qualification), the D stands for Driver, and the C stands for Constructor. The R D AVG column is easy enough, a simple average of all races.

I have trouble coming up with a formula for R C AVG. Here I would like Excel to print the average finishing position of all drivers of the same constructor, combined. Usually there are two, but sometimes three or four.

For the next column, R D Home, I would like to get the finishing position of a driver in his home race. E.g. Nico Rosberg's D HOME = GER, and his final position in GER was 4. Some drivers do not have a home race, so a null value for those is alright.

Finally, and I suppose the most difficult one, in the R C HOME column, I would like Excel to give me the average finishing position of all drivers racing for the same constructor, at the home race of the constructor. E.g. Neither Vettel or Raikkonen are Italian, but they race for an Italian constructor. Therefore I would like the average of their finishing positions printed in the R C HOME column.​

I have been playing around with VLOOKUP, MATCH, and IF commands for a couple of hours now, but I cannot seem to get it done. I really hope there is someone on these boards who
can help me out with this. To everyone still reading, thank you very much!



[TABLE="width: 2197"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]W[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]AA[/TD]
[TD]AB[/TD]
[TD="align: right"]AC[/TD]
[TD="align: right"]AD[/TD]
[TD="align: right"]AE[/TD]
[TD="align: right"]AF[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]DRIVER[/TD]
[TD]POS[/TD]
[TD]QUALITY[/TD]
[TD]SEASON[/TD]
[TD]D HOME[/TD]
[TD]CONSTRUCTOR[/TD]
[TD]C HOME[/TD]
[TD]AUS[/TD]
[TD]BAH[/TD]
[TD]CHI[/TD]
[TD]RUS[/TD]
[TD]SPA[/TD]
[TD]MON[/TD]
[TD]CAN[/TD]
[TD]EUR[/TD]
[TD]AUT[/TD]
[TD]BRI[/TD]
[TD]HUN[/TD]
[TD]GER[/TD]
[TD]BEL[/TD]
[TD]ITA[/TD]
[TD]SIN[/TD]
[TD]MAL[/TD]
[TD]***[/TD]
[TD]USA[/TD]
[TD]MEX[/TD]
[TD]BRA[/TD]
[TD]ABU[/TD]
[TD="align: right"]R D AVG[/TD]
[TD="align: right"]R C AVG[/TD]
[TD="align: right"]R D HOME[/TD]
[TD="align: right"]R C HOME[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Nico Rosberg[/TD]
[TD="align: right"]1[/TD]
[TD]Front[/TD]
[TD="align: right"]2016[/TD]
[TD]GER[/TD]
[TD]Mercedes[/TD]
[TD]GER[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3.19[/TD]
[TD="align: right"]3.48[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2.5[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Lewis Hamilton[/TD]
[TD="align: right"]2[/TD]
[TD]Front[/TD]
[TD="align: right"]2016[/TD]
[TD]BRI[/TD]
[TD]Mercedes[/TD]
[TD]GER[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3.76[/TD]
[TD="align: right"]3.48[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2.5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Daniel Ricciardo[/TD]
[TD="align: right"]3[/TD]
[TD]Front[/TD]
[TD="align: right"]2016[/TD]
[TD]AUS[/TD]
[TD]Red Bull[/TD]
[TD]AUT[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4.38[/TD]
[TD="align: right"]5.64[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3.5[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Sebastian Vettel[/TD]
[TD="align: right"]4[/TD]
[TD]Front[/TD]
[TD="align: right"]2016[/TD]
[TD]GER[/TD]
[TD]Ferrari[/TD]
[TD]ITA[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]7.29[/TD]
[TD="align: right"]7.40[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3.5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Max Verstappen[/TD]
[TD="align: right"]5[/TD]
[TD]Front[/TD]
[TD="align: right"]2016[/TD]
[TD]NED[/TD]
[TD]Red Bull[/TD]
[TD]AUT[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]6.90[/TD]
[TD="align: right"]5.64[/TD]
[TD]
[/TD]
[TD="align: right"]3.5[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Kimi Räikkönen[/TD]
[TD="align: right"]6[/TD]
[TD]Front[/TD]
[TD="align: right"]2016[/TD]
[TD]FIN[/TD]
[TD]Ferrari[/TD]
[TD]ITA[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7.52[/TD]
[TD="align: right"]7.40[/TD]
[TD]
[/TD]
[TD="align: right"]3.5[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Sergio Pérez[/TD]
[TD="align: right"]7[/TD]
[TD]Front[/TD]
[TD="align: right"]2016[/TD]
[TD]MEX[/TD]
[TD]Force India[/TD]
[TD]IND[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8.57[/TD]
[TD="align: right"]9.95[/TD]
[TD="align: right"]10[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Valtteri Bottas[/TD]
[TD="align: right"]8[/TD]
[TD]Front[/TD]
[TD="align: right"]2016[/TD]
[TD]FIN[/TD]
[TD]Williams[/TD]
[TD]BRI[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]9.67[/TD]
[TD="align: right"]10.52[/TD]
[TD]
[/TD]
[TD="align: right"]12.5[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Nico Hulkenberg[/TD]
[TD="align: right"]9[/TD]
[TD]Mid[/TD]
[TD="align: right"]2016[/TD]
[TD]GER[/TD]
[TD]Force India[/TD]
[TD]IND[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]11.33[/TD]
[TD="align: right"]9.95[/TD]
[TD="align: right"]7[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Fernando Alonso[/TD]
[TD="align: right"]10[/TD]
[TD]Mid[/TD]
[TD="align: right"]2016[/TD]
[TD]SPA[/TD]
[TD]McLaren[/TD]
[TD]BRI[/TD]
[TD="align: right"]21[/TD]
[TD]-[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11.60[/TD]
[TD="align: right"]11.83[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]12.5[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Felipe Massa[/TD]
[TD="align: right"]11[/TD]
[TD]Mid[/TD]
[TD="align: right"]2016[/TD]
[TD]BRA[/TD]
[TD]Williams[/TD]
[TD]BRI[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]11.38[/TD]
[TD="align: right"]10.52[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]12.5[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Carlos Sainz[/TD]
[TD="align: right"]12[/TD]
[TD]Mid[/TD]
[TD="align: right"]2016[/TD]
[TD]SPA[/TD]
[TD]Toro Rosso[/TD]
[TD]ITA[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]12.05[/TD]
[TD="align: right"]13.26[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]17.0[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]Romain Grosjean[/TD]
[TD="align: right"]13[/TD]
[TD]Mid[/TD]
[TD="align: right"]2016[/TD]
[TD]FRA[/TD]
[TD]Haas[/TD]
[TD]USA[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]13.86[/TD]
[TD="align: right"]14.45[/TD]
[TD]
[/TD]
[TD="align: right"]15.5[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Daniil Kvyat[/TD]
[TD="align: right"]14[/TD]
[TD]Mid[/TD]
[TD="align: right"]2016[/TD]
[TD]RUS[/TD]
[TD]Toro Rosso[/TD]
[TD]ITA[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]14.48[/TD]
[TD="align: right"]13.26[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]17.0[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Jenson Button[/TD]
[TD="align: right"]15[/TD]
[TD]Mid[/TD]
[TD="align: right"]2016[/TD]
[TD]BRI[/TD]
[TD]McLaren[/TD]
[TD]BRI[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]13.90[/TD]
[TD="align: right"]11.83[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12.5[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]Kevin Magnussen[/TD]
[TD="align: right"]16[/TD]
[TD]Mid[/TD]
[TD="align: right"]2016[/TD]
[TD]DEN[/TD]
[TD]Renault[/TD]
[TD]FRA[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]15.10[/TD]
[TD="align: right"]15.55[/TD]
[TD]
[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]Felipe Nasr[/TD]
[TD="align: right"]17[/TD]
[TD]Rear[/TD]
[TD="align: right"]2016[/TD]
[TD]BRA[/TD]
[TD]Sauber[/TD]
[TD]SWI[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]15.95[/TD]
[TD="align: right"]15.90[/TD]
[TD="align: right"]9[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]Jolyon Palmer[/TD]
[TD="align: right"]18[/TD]
[TD]Rear[/TD]
[TD="align: right"]2016[/TD]
[TD]BRI[/TD]
[TD]Renault[/TD]
[TD]FRA[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]16.00[/TD]
[TD="align: right"]15.55[/TD]
[TD="align: right"]18[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Pascal Wehrlein[/TD]
[TD="align: right"]19[/TD]
[TD]Rear[/TD]
[TD="align: right"]2016[/TD]
[TD]GER[/TD]
[TD]MRT[/TD]
[TD]BRI[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]17.29[/TD]
[TD="align: right"]17.65[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]20.5[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Stoffel Vandoorne[/TD]
[TD="align: right"]20[/TD]
[TD]Rear[/TD]
[TD="align: right"]2016[/TD]
[TD]BEL[/TD]
[TD]McLaren[/TD]
[TD]BRI[/TD]
[TD]-[/TD]
[TD="align: right"]10[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]11.83[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]Esteban Gutierrez[/TD]
[TD="align: right"]21[/TD]
[TD]Rear[/TD]
[TD="align: right"]2016[/TD]
[TD]MEX[/TD]
[TD]Haas[/TD]
[TD]USA[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]15.05[/TD]
[TD="align: right"]14.45[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]15.5[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]Marcus Ericsson[/TD]
[TD="align: right"]22[/TD]
[TD]Rear[/TD]
[TD="align: right"]2016[/TD]
[TD]SWE[/TD]
[TD]Sauber[/TD]
[TD]SWI[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15.86[/TD]
[TD="align: right"]15.90[/TD]
[TD]
[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]Esteban Ocon[/TD]
[TD="align: right"]23[/TD]
[TD]Rear[/TD]
[TD="align: right"]2016[/TD]
[TD]FRA[/TD]
[TD]MRT[/TD]
[TD]BRI[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]17.00[/TD]
[TD="align: right"]17.65[/TD]
[TD]
[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]Rio Haryanto[/TD]
[TD="align: right"]24[/TD]
[TD]Rear[/TD]
[TD="align: right"]2016[/TD]
[TD]***[/TD]
[TD]MRT[/TD]
[TD]BRI[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]20[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD="align: right"]18.67[/TD]
[TD="align: right"]17.65[/TD]
[TD]
[/TD]
[TD="align: right"]20.5

[/TD]
[/TR]
</tbody>[/TABLE]

 

[DRSteele]

Welcome to the forum.

This should do it. It is imperative you remove all the - in the empty cells where a racer did not participate in the race; just delete the contents of each of them. Also, the three * caused a headache because * is a wildcard text string in Excel; change the two occurrences to the code for Japan.

Enter these formulas in Row2, paying attention to the Ctrl+Shift+Enter method of invoking AF2. Copy downwards to Row25.

	AC	AD	AE	AF

<tbody>
[TD="align: center"]2[/TD]
[TD="bgcolor: #E2EFDA, align: right"]3.19[/TD]
[TD="bgcolor: #E2EFDA, align: right"]3.48[/TD]
[TD="bgcolor: #E2EFDA, align: right"]4.00[/TD]
[TD="bgcolor: #E2EFDA, align: right"]2.50[/TD]

</tbody>

Sheet10​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]AC2[/TH]
[TD="align: left"]=AVERAGE(H2:AB2)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]AD2[/TH]
[TD="align: left"]=AVERAGEIFS($AG$2:$AG$25,$F$2:$F$25,F2)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]AE2[/TH]
[TD="align: left"]=IFERROR(AVERAGEIFS($H2:$AB2,$H$1:$AB$1,E2),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="width: 10, bgcolor: #DAE7F5"]AF2[/TH]
[TD="align: left"]{=IFERROR(SUM(IFERROR((($F2=$F$2:$F$25)*($G2=$G$2:$G$25)*($G2=H$1:AB$1))*$H$2:$AB$25,0))/SUM(IF((F2=$F$2:$F$25)*(G2=$H$1:$AB$1)*$H$2:$AB$25>0,1,0)),"")}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try to enter the {} manually yourself.[/TD]
[/TR]
</tbody>[/TABLE]

 

[Brutor]

Thank you so much, DRSteele, for taking the time to write all that down. You just easily saved me three days of work. You rock! :D

 

[DRSteele]

Super. You're welcome.