excel怎么找人名负责项目多少个

=SUMPRODUCT((A$2:A$10=E2)/COUNTIFS(A$2:A$10,A$2:A$10,B$2:B$10,B$2:B$10))

=SUMIFS(C:C,A:A,E2)