|
本帖最后由 hasyh2008 于 2022-10-12 13:44 编辑
Sub 多条件统计()
Dim ar, br, r, str, d
Set d = CreateObject("scripting.dictionary")
ar = Sheet1.Cells(1, 1).CurrentRegion
For r = 2 To UBound(ar)
str = ar(r, 4) & ar(r, 3) & ar(r, 2) & ar(r, 5)
If ar(r, 6) >= 80 Then d(str) = d(str) + 1
Next r
br = Sheet2.Cells(1, 1).CurrentRegion
For r = 2 To UBound(br)
str = br(r, 1) & br(r, 2) & br(r, 3) & br(r, 4)
If d.exists(str) Then
br(r, 5) = d(str)
Else
br(r, 5) = 0
End If
Next r
Sheet2.Cells(1, 1).CurrentRegion = br
End Sub |
|