=SUMPRODUCT((A$2:A$1000="张三")*(C$2:C$1000="是"))/COUNTIF(C:C,"是")
=SUMPRODUCT((A$2:A$1000="张三")*(C$2:C$1000="否"))/COUNTIF(C:C,"否")
将公式的张三，分别换成其他人的姓名即可
300
300
299
298
298
298
298
297
295
295
2023-12-16 12:59
admin