close
1.如果數值儲存格是連續的EX.1(A1,A2,A3,A4,A5,A6,A7,A8)=SUM(A1:A8)EX.2(A1,A2,A3,A4,A5,A6,A7,A8,B1,B2,B3,B4,B5,B6,B7,B8)=SUM(A1:B8)2.如果數值儲存格不是連續的EX.3(A1,A4,A5,A7,A8,A11,A12)=SUM(A1 A4 A5 A7 A8 A11 A12)
全站熱搜
1.如果數值儲存格是連續的EX.1(A1,A2,A3,A4,A5,A6,A7,A8)=SUM(A1:A8)EX.2(A1,A2,A3,A4,A5,A6,A7,A8,B1,B2,B3,B4,B5,B6,B7,B8)=SUM(A1:B8)2.如果數值儲存格不是連續的EX.3(A1,A4,A5,A7,A8,A11,A12)=SUM(A1 A4 A5 A7 A8 A11 A12)