excel 两列对应项目相加

b2=COUNTIF($E$2:$E$11,A2)c2=SUMIF($E$2:$E$11,A2,$B$2:$B$11)