Sub TongLuong()
Dim Dic As Object, Darr(), Arr(), ShName As String, i As Long, j As Integer
Arr = Sheet3.Range("A2", Sheet3.Range("A65500").End(xlUp)).Value
Set Dic = CreateObject("scripting.dictionary")
For i = 1 To UBound(Arr)
Dic.Item(Arr(i, 1)) = i
Next i
ReDim Arr(1 To UBound(Arr), 1 To 1)
For s = 1 To Sheets.Count
If Sheets(s).Range("A4").Value = "STT" Then
i = Sheets(s).Range("D65500").End(xlUp).Row
j = Sheets(s).Range("AAA4").End(xlToLeft).Column
Darr = Sheets(s).Range("D5", Sheets(s).Cells(i, j)).Value
For i = 1 To UBound(Darr) - 4
For j = 1 To UBound(Darr, 2) Step 5
Key = Darr(i, j)
If Key <> "" Then
If Dic.exists(Key) Then Arr(Dic.Item(Key), 1) = Arr(Dic.Item(Key), 1) + Darr(i, j + 4)
End If
Next j
Next i
End If
Next s
Sheet3.Range("C2").Resize(UBound(Arr)) = Arr
End Sub