你可能感兴趣的试题
SUM(B1,B4) =SUM(B1:B4) =SUM(B1,B4) SUM(B1:B4)
SUM(A1:B4 B1:C4) SUM(B1+B4) SUM(B1+B2,B3+B4) SUM(B1,B2,B3,B4)
计算A1+B4 计算A1+A2+A3+A4+B1+B2+B3+B4 按行计算A列B行之和 按列计算列数1、2、3、4行之和
=AVERAGE(B2:B4) =SUM(B2:B4) =AVERAGE(B2,B3,B4) =(B2+B3+B4)/3
B3+B4 B4&B3 B3&B4 =B3; B4
4、2、5、2 2、3、4、5 5、4、3、2 4、2、5、3
=B3+B4 B3-B4 =B3&B4 B3$B4
计算A1与B4单元格中值的和 计算A1到B4单元格中值的和 按行计算A列和B列的和 按列计算1、2、3、4行的和
=SUM(A2:B4) =XX =SUM(XX) =A2+A3+A4+B2+B3+B4
SUM(A1:B4 B1:C4) SUM (B1+B4) SUM(B1+B2,B3+B4) SUM (B1, B2, B3, B4)
=AVERAGE(B2:B4) =SUM(B2:B4) =AVERAGE(B2,B3,B4) =(B2+B3+B4)/3
'=AVERAGE(B2:B4) '=SUM(B2:B4) '=AVERAGE(B2,B3,B4) '=(B2+B3+B4)/3
'=AVERAGE(B2:B4) '=SUM(B2:B4) '=AVERAGE(B2,B3,B4) '=(B2+B3+B4)/3
=AVERAGE(B2+B4) =SUM(B2:B4) =AVERAGE(B2,B3,B4) =(B2+B4)/3
按行计算A列和B列的平均值 计算A1到B4单元格的平均值 计算A1与B4单元格的平均值 按列计算第1行和第4行的平均值
=B2+B3+B4 =SUM(B2, B4) =SUM(B2.B4) =SUM(B2, B3, B4)
=B3+B4 =B3-B4 =B3&&B4 =B3$B4
=AVERAGE(B2:B4) =SUM(B2:B4) =AVERAGE(B2,B3,B4) =(B2+B3+B4)/3
计算A1+B4 计算A1+A2+A3+A4+BI+B2+B3+B4 按行计算A列B列之和 按列计算1、2、3、4行之和