=countif(排班表所在单元格区域,"=N") =countif(排班表所在单元格区域,"=A") =countif(排班表所在单元格区域,"=B") 如: =countif($A$2:$G$20,"=N")