Sub t1()
Dim i,t As Integer
t = Sheets(1).Range("a65536").End(xlUp).Row - 1
for i = 2 to 4
Sheets(2).Cells(i, 2) = Evaluate("=SUMPRODUCT(('sheet1'!a2:a" & t & "='sheet2'!A" & i & ")_
*('sheet1'!b2:b" & t & " like '*1*'))")
End Sub
Sub t1()
Dim s As String
Dim arr
' arr = [SUMPRODUCT((A2:A11=E1)*(MID(B2:B11,2,1)="1"))] ' 可以这样
s = "=SUMPRODUCT((A2:A11=E1)*(MID(B2:B11,2,1)=""1""))" ' 正确
' s = "SUMPRODUCT((A2:A11=F1)*(MID(B2:B11,2,1)=""1"")" ' 少一边括号
arr = Evaluate(s)
Cells(2, 5) = arr
End Sub
Sub t1()
Dim s As String
Dim arr
' arr = [SUMPRODUCT((A2:A11=E1)*(MID(B2:B11,2,1)="1"))] ' 可以这样
s = "=SUMPRODUCT((A2:A11=E1)*(MID(B2:B11,2,1)=""1""))" ' 正确
' s = "SUMPRODUCT((A2:A11=F1)*(MID(B2:B11,2,1)=""1"")" ' 少一边括号
arr = Evaluate(s)
Cells(2, 5) = arr
End Sub