老师,怎么用excel函数在多个工作表里找一个名字出现的次数呀
![](/wenda/images/newWd/search.png)
问题已解决
所属话题:
#Excel#
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84784961 | 提问时间:2019 06/14 12:42
假设姓名区域在A1-A100
=countif(sheet1!A1:A100,=张三)+countif(sheet2!A1:A100,=张三)+countif(sheet3!A1:A100,=张三)+countif(sheet4!A1:A100,=张三)+countif(sheet5!A1:A100,=张三)+............+countif(sheetN!A1:A100,=张三)
SHEET1 -SHEETN 替换为你的工作边名称,确定好区域就行了
![](https://al3.acc5.com/10160525_5d032c76b480b.png)
2019 06/14 13:11
相关问答
查看更多最新问答
查看更多