C列输入什么公式可用统计出每组合格的次数啊
C2公式:=IF(COUNTIF($A$2:$A2,A2)=1,COUNTIFS($A$2:$A$10000,A2,$B$2:$B$10000,"合格"),"")
G1=SUMIFS($C$1:$C$10,$A$1:$A$10,F1,$B$1:$B$10,$E$1)