excel有价格和金额两列,底部小计为两列的合并单元格,如何求金额的和 并...答:假设你说的两列是B,C两列,B列为价格,C列为金额,数据在B2至C100单元格 "小计"两字所在单元格为A101单元格,B101和C101为合并单元格 则B101单元格写入公式 =SUM(C2:C100)EXCEL四则运算 以A1至A5区域及B6单元格式为例,A1至A5分别为1,2,3,4,5,B6为6 加法 =SUM(A1:A5,B6)=A1+A2+A3+A4+...
如何在EXCEL表中自动插入小计行,并对指定列求和答:Sub 小计求和()Dim x As Integer, m1, m2, k, nx = 1Dox = x + 1If Cells(x, 1) <> Cells(x - 1, 1) Then m1 = xIf Cells(x, 1) <> Cells(x + 1, 1) Then m2 = xIf m1 <> "" And m2 <> "" ThenRows(x + 1).InsertCells(x + 1, "c") = "小计" ...