函数题目！

=BYCOL(B2:M39,LAMBDA(x,ROUND(SUM(DROP(GROUPBY(IFNA(MATCH(ROW(x)-1,MATCH(QUARTILE(x,{0,4}),x,),),A2:A39),x,AVERAGE,,0),2,1)*O2:O7),1)))

额，想多了

A1={"","杨任的","蒋榕身","沈码身","李和属","张润冰","姜由昕";"A",47.6,1.2,40.3,41.9,40.6,44;"A",76.3,83.4,69.1,99.7,98.4,3;"A",74.3,99.5,68.1,99.4,79.3,89.5;"A",66.1,42.9,41,70.9,87.9,83.8;"A",96.2,79.2,52.1,85.4,99.1,50.8;"A",79.4,43.9,79.9,43.2,91.3,53.4;"A",96.5,42.3,50,80.2,95.4,88.2;"A",91.4,83,85.5,73.5,83.9,59.3;"A",72.1,59.4,53.6,77.7,98.3,62;"B",49.2,61.6,66.7,69.7,65.7,82.1;"B",70.1,1.2,98.3,99.7,71.9,81.6;"B",96.2,72.2,76.8,99.7,73.5,4;"B",87.8,70.1,52.6,41.9,73.8,43.3;"B",45.3,48,76,82.6,97,43.3;"B",96.5,42.5,83.7,55.4,73.1,92.7;"B",41.3,57.1,41,93.9,55.6,63.2;"B",67.3,46.6,86.2,96.4,65.4,82.6;"C",85.3,73.3,85.1,85.5,99.1,73.5;"C",47.8,67.2,64.8,99.7,93.8,58.4;"C",72.2,42.3,89.4,89.9,41.3,60.2;"C",54.3,51.5,75.4,53.3,81.8,43.3;"C",86.6,78.1,86.6,99.5,65.7,95.7;"C",45.7,99.5,96.6,62.2,74.2,69.6;"D",42.8,64.1,66.9,70.7,42.8,69.3;"D",79.8,71.2,60.2,90.2,83.9,64.7;"D",56.6,97.2,58.1,50.5,43.5,88.4;"D",59.3,71,48.9,99.7,61,79.6;"D",70.6,45.9,79.6,46.9,99.1,58.4;"D",41.3,42.3,57.8,59.8,65.3,95.4;"D",46.9,66.1,91.6,71,78.4,53.9;"E",83.5,42.8,98.3,77.9,68.7,0.9;"E",41.6,79.1,79.3,99.7,40.6,0.9;"E",86.8,72,74.6,52.1,63.2,43.9;"E",93.2,61.2,78.2,91,68.3,43.3;"F",96.5,68.5,90.3,99.7,67.6,95.6;"F",96.5,99.5,40.3,64.3,56.6,96.1;"F",88.1,79.6,59.3,64.1,84.3,96.1;"F",60,1.2,40.3,41.9,40.6,49.1}

H1={"魏成建","沈瑞网","郑后慧","朱敏须","杨通莎","曹不息";57.2,84,87,99.5,94.6,48;81.8,61.8,2,99.5,85,93.1;64.4,72.7,97.9,68.6,83,96.7;90,40.6,2,63.2,69,48.4;63.8,89.4,76,41.2,58,54;40.7,55.6,87.3,87.2,57.1,42.4;74.9,98.1,96.6,60.8,54.6,87.4;79.8,50.1,57.1,67,80.7,58;44.8,40.6,66.7,86.2,47.9,83.5;65.2,66,52.1,92.2,47.7,95.7;52.2,46.6,41.5,74.4,82.1,61;63.9,72.7,70.9,75.1,61,41;81.7,48.5,2,77.3,61.5,60.2;40.7,56.1,64.7,78,72.1,85.3;75.4,40.6,43.1,54.1,59.4,41;92.2,65.9,96.6,88.9,49,51.5;43.6,84.2,91.6,41.2,68.2,61.7;55.9,59.3,41.7,69.5,94.6,68;40.7,72.4,83.3,96.3,90.7,74.4;52.5,72.7,60.9,85.9,41.1,57.8;95.2,68.1,81.4,73,63,41;99.8,41.3,73.8,52.5,64,48.8;99.8,62.4,96.6,41.2,78.9,41;87.6,40.6,83.3,85.9,94.6,51.6;79.7,68.1,83.5,64.5,94.6,89.9;45.9,87.3,71,90.1,87.9,72.9;42.6,90,65.8,92.4,78,42.8;72.8,53.1,97.9,63.1,46.3,41;63.6,48.1,41.5,42.4,64.1,54.2;81.7,86.8,78.1,66.7,76.3,78.7;70.6,93.7,87.4,66.9,40.8,84.9;72.4,98.1,61.3,55.8,40.4,54.3;68.8,91.9,52.7,89.6,52.3,46.7;75.5,65.2,74.5,60,79.7,75.4;86.6,49.1,91,70.2,40.4,99;99.2,57.9,2,48.4,51.4,90.3;57.2,55,42.1,86.2,60.3,56.3;99.2,51.4,97.9,99.5,94.6,99.8}

N1={"部门","比例";"A",0.372;"B",0.4431;"C",0.5974;"D",0.6801;"E",0.7354;"F",0.8029}

N8={"模拟答案",262.7,227.5,255.3,273,251.3,224.8,263.1,241.2,242.4,262.4,240.2,242.8}