会弄就参考我的代码自己折腾,不会弄就下载附件我弄好的!
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc79e344f7fd900baa1cd112a68?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
Option Explicit
Sub sMerge()
Dim i As Integer, k As Integer
Dim t As Double, l As Double
With Sheet1
For i = 5 To 1136
If .Range("b" & i).MergeCells Then
If .Range("b" & i).MergeArea.Count > 1 Then
k = .Range("b" & i).MergeArea.Count - 1
t = Application.Sum(.Range("k" & i & ":k" & i + k))
l = Application.Sum(.Range("l" & i & ":l" & i + k))
.Range("c" & i) = "合计:" & vbCrLf & k + 1 & "块" & vbCrLf & t & "亩"
.Range("d" & i) = "合计:" & vbCrLf & k + 1 & "块" & vbCrLf & l & "亩"
i = i + k
Else
.Range("c" & i) = .Range("k" & i)
.Range("d" & i) = .Range("l" & i)
End If
End If
Next i
End With
End Sub