Método de puntuación de la tabla de resumen de resultados de reuniones deportivas en Excel

=(LARGO($C5)-LARGO(SUSTITUIR($C5,I$3&";","")))/4*ELEGIR(LARGO($C5)-LARGO(SUSTITUIR($ C5,";",""))+1,1,7,6,16/3,19/4,21/5,22/6)+(LEN($D5)-LEN(SUSTITUTO($D5, I$3&";","")))/4*ELEGIR(LEN($D5)-LEN(SUSTITUIR($D5,";",""))+1,1,5,9/2,4 ,14/4,3)+(LEN($E5)-LEN(SUSTITUTO($E5,I$3&";","")))/4*ELIJA(LEN($E5)-LEN(SUSTITUTO($ E5,";",""))+1,1,4,7/2,3,10/4)+(LEN($F5)-LEN(SUSTITUTO($F5,I$3&";"," ")))/4*ELIJA(LARGO($F5)-LARGO(SUSTITUIR($F5,";",""))+1,1,3,5/2,2)+(LARGO($G5) -LEN(SUSTITUTO($G5,I$3&";","")))/4*ELEGIR(LEN($G5)-LEN(SUSTITUTO($G5,";",""))+1,1 ,2,3/2)+(LARGO($H5)-LARGO(SUSTITUIR($H5,I$3&";","")))/4