你可能感兴趣的试题
SUM(A1*A4) =A1+A4 SUM(A1/A4) =A1+A2+A3+A4
=A1+A2/2 =A1+A3/2 =(A1+A2+A3)/3 =A1+A2+A3/A1*A2*A3
SUM(A1:4B1:C4) SUM(B1+4) SUM(B1+2,B3+B4) SUM(B1,2,B3,B4)
=A1+A2/2 =A1+A3/2 =(A1+A2+A3)/3 =A1+A2_A3/A1*A2*A3
SUM(A1*A4) SUM(A1+A4) SUM(A1/A4) SUM(A1+A2+A3+A4)
A1+A4 A1+A2+A3+A4 A1*A4 A1-A4
=A1+A2+A3+A4/4 =(A1+A2+A3+A4) /4 =(A1+A4) /4 =A1+A2+A3+A4
计算A1与B4单元格中值的和 计算A1到B4单元格中值的和 按行计算A列和B列的和 按列计算1、2、3、4行的和
=A1+A2+A3+A4 =A1+A2+A3+A4/4 =(A1+A2+A3+A4)/4 =(A1+A2+A3+A4)/4
=(sum)A1:A5 =sum(A2,B3,B7) =sumA1:A5 =sum(A10,B5:B10:28)
=A1+A2/2 =A1+A3/2 (A1+A2+A3)/3 A1+A2+A3/A1*A2*A3