1,451
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
fredlin 2004-11-23
- 打赏
- 举报
SUM(R1C2,R3C5,R6C2,R1C7)
SUM(A1,B7,C11)
SUM(A1:A9)
SUM(95,89,73,87,85,76,100,96,96)=797
SUM(A1,B7,C11)
SUM(A1:A9)
SUM(95,89,73,87,85,76,100,96,96)=797
wwqna 2004-11-19
- 打赏
- 举报
SUM
--------------------------------------------------------------------------------
Name
Summation
Description
Sums cells or blocks.
Syntax
SUM(value1, value2, . . . )
Remarks
Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.
See also ADD and SUMSQ.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Types for Formula Functions.
Example
SUM(R1C2,R3C5,R6C2,R1C7)
SUM(A1,B7,C11)
SUM(A1:A9)
SUM(95,89,73,87,85,76,100,96,96)=797
--------------------------------------------------------------------------------
Name
Summation
Description
Sums cells or blocks.
Syntax
SUM(value1, value2, . . . )
Remarks
Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.
See also ADD and SUMSQ.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Types for Formula Functions.
Example
SUM(R1C2,R3C5,R6C2,R1C7)
SUM(A1,B7,C11)
SUM(A1:A9)
SUM(95,89,73,87,85,76,100,96,96)=797
