if、counf、countif、countifs、sumif、sumifs
评分等级:=IF(C3>=90,"优秀",IF(C3>=80,"良好",IF(C3>=60,"及格","不及格")))
求男生的数学总成绩:=SUMIF(B3:B21,"男",C3:C21)
求合格男生的数学总成绩:=SUMIFS(C3:C21,C3:C21,">60",B3:B21,"男")
统计人数:=COUNT(C3:C21)
数学成绩大于80人数:=COUNTIF(C3:C21,">80")
数学成绩大于80的男生人数:=COUNTIFS(C3:C21,">80",B3:B21,"男")
学习时的痛苦是暂时的,未学到的痛苦是终生的