|
求多工作表同一区域条件计数,请大师帮忙修改或精简一下,谢谢!
=COUNTIF(I4:I23,2013)+COUNTIF('(2)'!I4:I23,2013)+COUNTIF('(3)'!I4:I23,2013)+COUNTIF('3-2'!I4:I23,2013)+COUNTIF('4-1(1)'!I4:I23,2013)+COUNTIF('4-2(1)'!I4:I23,2013)+COUNTIF('4-1(2)'!I4:I23,2013)+COUNTIF('4-3'!I4:I23,2013)+COUNTIF('(5)'!I4:I23,2013)+COUNTIF('(6)'!I4:I23,2013)+COUNTIF('(7)'!I4:I23,2013)+COUNTIF('(8)'!I4:I23,2013)+COUNTIF('9-1(1)'!I4:I23,2013)+COUNTIF('9-1(2)'!I4:I23,2013)+COUNTIF('9-2 (1)'!I4:I23,2013)+COUNTIF('9-2 (2)'!I4:I23,2013)+COUNTIF('9-3'!I4:I23,2013)+COUNTIF('(10)'!I4:I23,2013)
cdnyrg 发表于 2013-11-28 16:28
求怎么设置?不懂 - Function Xcount(x As Integer)
- Dim i As Integer, n As Integer, m As Integer
- Application.Volatile
- For i = 1 To Sheets.Count
- n = Application.CountIf(Sheets(i).Range("I2:I100"), x)
- m = m + n
- Next i
- Xcount = m
- End Function
复制代码
|
|