第3题:不会,求指教!
第4题:应参加考试人数 =COUNTA(C16:C38)
实际参加考试人数 =COUNTA(D16:D38)
全班总分 =SUM(G16:G38)
>=60的及格人数为 =COUNTIF(D16:D38,">=60")
>=80的优秀人数为 =COUNTIF(D16:D38,">=80")
语文总分 =SUM(INDEX(A16:G39,,MATCH(D15,A15:G15,)))
第5题:=VLOOKUP($F$18,$B$18:$D$26,COLUMN(B:B),)
=LOOKUP($F$18,$B$18:$B$26,C18:C26) (升序)
=INDEX($B$18:$D$26,MATCH($F$18,$B$18:$B$26,),COLUMN(B:B))
=LOOKUP(F32,$B$32:$C$35)
=SUMPRODUCT((B44:B49=F44)*(C44:C49=G44),D44:D49)
=SUMIF(B55:B59,"*b*",C55:C59)
|