- Sub 汇总()
- Dim MO As Byte
- For MO = 3 To 14
- Sheets("汇总").Cells(MO, 2) = WorksheetFunction.SumIf(Sheets("数据库").Columns(1), _
- Sheets("汇总").Cells(MO, 1), Sheets("数据库").Columns(8))
- Sheets("汇总").Cells(MO, 3) = WorksheetFunction.SumIf(Sheets("数据库").Columns(1), _
- Sheets("汇总").Cells(MO, 1), Sheets("数据库").Columns(12))
- Sheets("汇总").Cells(MO, 4) = WorksheetFunction.SumIf(Sheets("数据库").Columns(1), _
- Sheets("汇总").Cells(MO, 1), Sheets("数据库").Columns(16))
- Sheets("汇总").Cells(MO, 5) = Sheets("汇总").Cells(MO, 2) + Sheets("汇总").Cells(MO, 3) + _
- Sheets("汇总").Cells(MO, 4)
- Next MO
- Sheets("汇总").[B15] = WorksheetFunction.Sum(Sheets("汇总").[B3:B14])
- Sheets("汇总").[C15] = WorksheetFunction.Sum(Sheets("汇总").[C3:C14])
- Sheets("汇总").[D15] = WorksheetFunction.Sum(Sheets("汇总").[D3:D14])
- Sheets("汇总").[E15] = WorksheetFunction.Sum(Sheets("汇总").[E3:E14])
- End Sub
复制代码 |