假设姓名区域在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 替换为你的工作边名称,确定好区域就行了
温馨提示:答案为网友推荐,仅供参考