Sub 计算()
Sheet2.Activate
rw = Cells(Rows.Count, 1).End(3).Row
For i = 4 To rw
Range("F" & i).Value = Evaluate("SUMIF(Sheet1!A:A," & Cells(i, 1) & ",Sheet1!E:E)")
Next
End Sub
Sub 计算()
rw = Cells(Rows.Count, 1).End(3).Row
For i = 4 To rw
Dim rgg As Integer
rgg = Sheet2.Range("A" & i)
Sheet2.Range("F" & i).Value = Evaluate("SUMIF(Sheet1!A:A,rgg,Sheet1!E:E)")
Next
End Sub
梦想有多远 发表于 2015-1-31 22:12
Sub 计算()
rw = Cells(Rows.Count, 1).End(3).Row
For i = 4 To rw
Sub 计算()
rw = Cells(Rows.Count, 1).End(3).Row
For i = 4 To rw
Dim rgg As Integer
rgg = Sheet2.Range("A" & i)
Sheet2.Range("F" & i).Value = Evaluate("SUMIF(Sheet1!A:A,rgg,Sheet1!E:E)")
Next
End Sub
Sub 计算()
Sheet2.Activate
rw = Cells(Rows.Count, 1).End(3).Row
For i = 4 To rw
Range("F" & i).Value = Evaluate("SUMIF(Sheet1!A:A," & Cells(i, 1) & ",Sheet1!E:E)")
Next
End Sub
Sub 计算()
Sheet2.Activate
rw = Sheet2.Cells(Rows.Count, 1).End(3).Row
For i = 4 To rw
Sheets("汇总").Range("F" & i).Value = "=SUMIF(台账!A:A," & Cells(i, 1) & ",台账!E:E)"
Next
End Sub
老师改成这样就可以了,谢谢你的解答