怎么把excel里的列A里的每四行求和一次把值放到b列中以从A1开始到A12结束为例子:b1=sum(a1:a4),b2=sum(a1:a4),b3=sum(a1:a4),b4=sum(a1:a4),b5=sum(a5:a8),b6=sum(a5:a8),b7=sum(a5:a8),b8=sum(a5:a8),b9=sum(a9:a12),b10=sum(a9:a12)
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/24 09:54:10
![怎么把excel里的列A里的每四行求和一次把值放到b列中以从A1开始到A12结束为例子:b1=sum(a1:a4),b2=sum(a1:a4),b3=sum(a1:a4),b4=sum(a1:a4),b5=sum(a5:a8),b6=sum(a5:a8),b7=sum(a5:a8),b8=sum(a5:a8),b9=sum(a9:a12),b10=sum(a9:a12)](/uploads/image/z/11524096-64-6.jpg?t=%E6%80%8E%E4%B9%88%E6%8A%8Aexcel%E9%87%8C%E7%9A%84%E5%88%97A%E9%87%8C%E7%9A%84%E6%AF%8F%E5%9B%9B%E8%A1%8C%E6%B1%82%E5%92%8C%E4%B8%80%E6%AC%A1%E6%8A%8A%E5%80%BC%E6%94%BE%E5%88%B0b%E5%88%97%E4%B8%AD%E4%BB%A5%E4%BB%8EA1%E5%BC%80%E5%A7%8B%E5%88%B0A12%E7%BB%93%E6%9D%9F%E4%B8%BA%E4%BE%8B%E5%AD%90%EF%BC%9Ab1%3Dsum%28a1%3Aa4%29%2Cb2%3Dsum%28a1%3Aa4%29%2Cb3%3Dsum%28a1%3Aa4%29%2Cb4%3Dsum%28a1%3Aa4%29%2Cb5%3Dsum%28a5%3Aa8%29%2Cb6%3Dsum%28a5%3Aa8%29%2Cb7%3Dsum%28a5%3Aa8%29%2Cb8%3Dsum%28a5%3Aa8%29%2Cb9%3Dsum%28a9%3Aa12%29%2Cb10%3Dsum%28a9%3Aa12%29)
怎么把excel里的列A里的每四行求和一次把值放到b列中以从A1开始到A12结束为例子:b1=sum(a1:a4),b2=sum(a1:a4),b3=sum(a1:a4),b4=sum(a1:a4),b5=sum(a5:a8),b6=sum(a5:a8),b7=sum(a5:a8),b8=sum(a5:a8),b9=sum(a9:a12),b10=sum(a9:a12)
怎么把excel里的列A里的每四行求和一次把值放到b列中
以从A1开始到A12结束为例子:b1=sum(a1:a4),b2=sum(a1:a4),b3=sum(a1:a4),b4=sum(a1:a4),b5=sum(a5:a8),b6=sum(a5:a8),b7=sum(a5:a8),b8=sum(a5:a8),b9=sum(a9:a12),b10=sum(a9:a12),b11=sum(a9:a12),b12=sum(a9:a12)有没有公式来计算?
怎么把excel里的列A里的每四行求和一次把值放到b列中以从A1开始到A12结束为例子:b1=sum(a1:a4),b2=sum(a1:a4),b3=sum(a1:a4),b4=sum(a1:a4),b5=sum(a5:a8),b6=sum(a5:a8),b7=sum(a5:a8),b8=sum(a5:a8),b9=sum(a9:a12),b10=sum(a9:a12)
B1单元格写入公式
=SUM(OFFSET(A$1,ROW(A1)*4-4,4,))
或
=SUM(OFFSET(A$1:A$4,ROW(A1)*4-4,))
下拉复制公式
不对,你要的是
b1=sum(a1:a4),b2=sum(a1:a4),b3=sum(a1:a4),b4=sum(a1:a4).
B1单元格公式改成
=SUM(OFFSET(A$1,INT((ROW(A1)-1)/4)*4,4,))
或
=SUM(OFFSET(A$1:A$4,INT((ROW(A1)-1)/4)*4,))
下拉复制公式