- ·上一篇：excel表格怎么固定行头
- ·下一篇：excel表格学生等级怎么弄
excel表格表通过率怎么弄
2025-07-25 15:36:51
1.Excel中如何计算某个人的通过率
=SUMPRODUCT((A:A="小王")*（B:B="审核通过"））/COUNTIF(A:A，"小王")
=SUMPRODUCT((A:A=C1)*(B:B="审核通过")）/COUNTIF(A:A,C1)
=SUMPRODUCT((A:A="小王")*（B:B="审核通过"））/COUNTIF(A:A，"小王")
=SUMPRODUCT((A:A=C1)*(B:B="审核通过")）/COUNTIF(A:A,C1)