1.countif2.VLOOKUP3.right/left/mid4.find5.sumifs 1.countif常见：=”ASP项目共计”&countif(A1:B1,”ASP”)&”个”=”成绩低于60分的”&countif(A1:B1,”<60”)&”人” 2.VLOOKUP常见: 3.right/left/mid 4.find 5.sumifs
