Description
Use this function to return the sum of values supplied. Supported in Chains. Can be used with CHILDREFS.
語法
SUM(number, […, [number_254])
Inputs
This function accepts the following arguments:
| 名稱 | 必要 | 說明 | Valid input |
|---|---|---|---|
number_1 |
是 | The first number to be added. | A cell reference, a number, or a formula which results in either of these. |
number_n |
沒有 | Additional numbers to be added. | A cell reference (including a range), a number, or a formula which results in either of these. |
範例
範例資料
| A | B |
|---|---|
| 51 | 56 |
| 93 | 39 |
| egg | 15 |
| 19 | 92 |
| 75 | 22 |
Sample formulas
| 公式 | 說明 | 結果 |
|---|---|---|
=SUM(1) |
Adds the number "1". | 1 |
=SUM(A1:A7) |
Adds the values in cells A1 through A7 inclusive. The value in cell A3, being text, is treated as "0". | 305 |
=SUM(A1:A2, B5) |
Adds the values in cells A1 through A2 inclusive, plus the value of cell B5. | 206 |
=SUM(A1:A2, B2:B5) |
Adds the values in cells A1 through A2 inclusive, plus the values in cells B1 through B5 inclusive. | 675 |
附註
- SUM automatically ignores empty cells.
- If text is included by a cell or range reference, then it is treated as a zero.
- If text is included without quotation marks, the function returns a #NAME! error. If text is included with quotation marks, the function returns a #VALUE! error.
- If arguments contain errors, SUM will return an error.
- SUM can handle up to 255 total arguments.
- Wildcards don't work with this function.
提示
TBD
Related functions
ABS
EXP
LN
MOD
N
POWER
PRODUCT
SIGN
SQRT
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT