|
不想用公式,那就給你VBA代碼吧,寫的不是很好,勉強可以用
- Sub SumMergedCells()
- Dim lastRow As Long
- Dim i As Long, j As Long
- Dim mergeRange As Range
- Dim mergeValue As Variant
- Dim sumValue As Double
- lastRow = Cells(Rows.Count, "A").End(xlUp).Row
- For i = 1 To lastRow
- If Range("A" & i).MergeCells Then
- Set mergeRange = Range("A" & i).MergeArea
- mergeValue = mergeRange.Value
- sumValue = 0
- For j = mergeRange.Row To mergeRange.Row + mergeRange.Rows.Count - 1
- sumValue = sumValue + Cells(j, "B").Value
- Next j
- mergeRange.Cells(1, 1).Offset(0, 2).Value = sumValue
- mergeRange.Value = mergeValue
- Else
- Cells(i, "C").Value = Cells(i, "B").Value
- End If
- Next i
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|