你可能感兴趣的试题
求B3到B5三个单元格的和 求B3到B5三个单元格的平均值 求B3和B5三个单元格的和 求B3和B5三个单元格的平均值
=$A$2+$A$3 =A2+A3 =A:2+A:3 =SUM(A2:A3)
=(SUM)A1:A5 =SUM(A2,B3;B7) =SUM A1:A5 =SUM(A10,B5:B10,28)
(a2,b5,7) (a6,b5,3) (a7,b7,8) (a8,b4,1)
=SUM(A2:A5) =SUMIF(A2:A5,800,B2:B5) =COUNTIF(A2:A5,800) =SUM(B2:B5,800,A2:A5)
=(sum)A1、A5 =sum(A2,B3,B7) =sumAl、A5 =sum(A10,B5、B10、28)
=SUM(A1:B5 B1:C5) =SUM(B1,B2,…,B5) =SUM(B1+B2,B3+B4,B5) =SUM(B1,B2,B3,84,B5)
=(sum)A1:A5 =sum(A2,B3,B7) =sumA1:A5 =sum(A10,B5:B10:28)
计算B1,B3,B4,B5各单元格值的和,并将结果放入B7单元格中 计算B1,B2,B3,B4,B5各单元格值的和,并将结果放入B7单元格中 计算B1,B3,B5各单元格值的和,并将结果放入B7单元格中 计算B1,B2,B3,B5各单元格值的和,并将结果放入B7单元格中
=(sum) A1:A5 =sum(A2, B3, B7) =sum A1:A5 =sum(A10, B5:B10: 28)
1001,1002,1003,2,3,4,1007 2,3,1003,1004,2,3,1007 1001,1002,1003,5,7,11,13 5,7,11,13,1005,1006,1007