|
发表于 2016-4-13 10:36
|
显示全部楼层
本楼为最佳答案
- Sub 统计()
- Dim L1, L2, Ls, xMin, xMax
- L1 = [ax2]: L2 = [ax3]: Ls = L2 - L1 + 1 '要统计的列,列数
- xMin = [ax4]: xMax = [ax5] '和值区间
- arr = Range("J7:AS37") '数据区域,根据实际情况自调
- ReDim brr(1 To UBound(arr), 1 To 1)
- c1 = L1 - 3 '根据要统计起始列换算数据区域中的列数
- For i = 1 To UBound(arr)
- brr(i, 1) = 0
- For j = c1 To UBound(arr, 2) Step 12
- s = 0
- For k = 1 To Ls
- s = s + arr(i, j + k - 1)
- Next
- If s >= xMin And s <= xMax Then brr(i, 1) = brr(i, 1) + 1
- Next
- Next
- [az7].Resize(UBound(brr)) = brr
- End Sub
复制代码 |
评分
-
查看全部评分
|