excel中C1=A1+A2+B1+B2下拉 c2=a3+a4+b3+b4怎么设置？

Question

如题所述

Answer 1

'自定义公式-按ALT+11-插入-模块(隔行相加)
Function 隔行相加(a As Integer)
m = 1
For i = 1 To 100
If i = a Then 隔行相加 = Cells(m, 1) + Cells(m + 1, 1) + Cells(m, 2) + Cells(m + 1, 2)
m = m + 2
Next
If 隔行相加 = 0 Or 隔行相加 = "" Then 隔行相加 = ""
End Function

Answer 2

=INDIRECT("A"&ROW(A1)*2-1)+INDIRECT("A"&(ROW(A1)*2))+INDIRECT("B"&ROW(A1)*2-1)+INDIRECT("B"&(ROW(A1)*2))

手机打的，不容易，望采纳！

Answer 3

这个二个公式输入后，现在选择C1:C2，记住必须是要二个单元格一起！复制并下拉即可

Answer 4

直接下拉 就是的吖