=COUNTIF(考勤!ADDRESS(4,MATCH(K2,考勤!$A$2:$HZ$2),3):ADDRESS(4,MATCH(K3,考勤!$A$2:$HZ$2)+1,3),C$1)
excel提示公式错误
countif的第一区域必须是range对象,或者间接引用,比如offset,indirect
公式改成下面的试试.
=COUNTIF(indirect(考勤!ADDRESS(4,MATCH(K2,考勤!$A$2:$HZ$2),3)&":"&ADDRESS(4,MATCH(K3,考勤!$A$2:$HZ$2)+1,3)),C$1)
|