需要在单元格F6输入该公式=SUMIF('2月'!C:C,"J"&B6,'2月'!E:E) (fx里面显示为这个) 但这里的'2月'!需要设置为变量变量,求教老师怎么输入
[此贴子已经被作者于2009-12-16 22:08:36编辑过]
[em01] Sub a() Dim sh As Worksheet Dim bm As String Dim i As Integer For Each sh In ThisWorkbook.Sheets bm = sh.Name i = i + 1 Cells(i, 1).Formula = "=SUMIF('" & bm & "'!C:C,""J""&B6,'" & bm & "'!E:E)" Next End Sub
|