|
本帖最后由 苏子龙 于 2016-10-7 19:18 编辑
- Sub tt()
- Dim sh As Worksheet
- Dim arr
- Sheets("工件合计").Range("b2:c6").Clear
- arr = Sheets("工件合计").Range("a1").CurrentRegion
- For Each sh In ThisWorkbook.Worksheets
- If sh.Name <> "工件合计" Then
- For i = 2 To 6
- arr(i, 2) = arr(i, 2) + Application.SumIf(sh.Range("b2:f2"), arr(i, 1), sh.Range("b34:f34"))
- arr(i, 3) = arr(i, 3) + Application.SumIf(sh.Range("b2:f2"), arr(i, 1), sh.Range("b36:f36"))
- Next i
- End If
- Next
- Sheets("工件合计").Range("a1").Resize(6, 3) = arr
- End Sub
复制代码 |
|