Sub zj()
Dim arr, i%, x
r = Sheet1.Range("a65536").End(3).Row
arr = Sheet1.Range("a3:k" & r)
For i = UBound(arr) To 1 Step -1
If arr(i, 1) Like "*产品*" Then
arr(i, 11) = "=sum(j" & i + 2 & ":j" & i + 2 + x & ")"
x = 0
Else
x = x + 1
End If
Next i
[a3].Resize(UBound(arr), 11) = arr
End Sub