你可能感兴趣的试题
=sum(B$3:E$3) =sum(C3:F3) =sum(B2:E2) =sum(B3:E3)
=sum($B2:$E2) =sum($C3:$F3) =sum($B3:$E3) =sum(B$3:E$3)
=SUM(B2:E4) =SUM(B2:E5) =SUM(B2:C4) =SUM(B2:E3)
=SUM(B2:E4) =SUM(B2:E5) =SUM(B2:D3) =SUM(B2:E3)
B1:C4 B1:C2,C3:C4 B1:C2:C4 B1:C2C3:C4
A1、A2 和 A3 A4、B4 和 C4 B1、B2 和 B3 C1、C2 和 C3
B2:E3 B3: E2 E2: B3 E3: B2
=AVERAGE(B1+B2+B3) =AVERAGE(B1/3,B2/3,B3/3) =(B1+B2+B3)/3 =AVERAGE(A1:B3 B1:C3)
A1、A2 和 A3 A4、B4 和 C4 B1、B2 和 B3 C1、C2 和 C3
A1*A3+C1*C3 A1*A2+C1*C2 B1*B3+C1*C3 A2*A3+C2*C3
=sum(B$3:E$3) =sum($C3:$F3) =sum($B3:$E3) =sum($B2:$E2)
=SUM(B2:E4) =SUM(B2:E5) =SUM(B2: D3) =SUM(B2: E3)
A2,C3 A2,B2,C3 A2,B2,C2 A2,B2,C2,A3,B3,C3
=SUM(A1, B2: C3) =SUM(A1: C2) =SUM(A1, B2, C3) =SUM(A1: B2: C3)
A1 B1 C1 A2、A3、B2、B3、C2、C3