ADDNUMBERS
ADDNUMBERS(number1, number2)
Returns the sum of a group of numbers.
number1 | The first number. |
number2 | (Optional) The second number. |
Remarks
* This function excludes hidden rows.
* Arguments that are logical values are excluded.
* Arguments that are text are excluded.
| A | 1 | =JS.ADDNUMBERS(10,20) | 2 | =JS.ADDNUMBERS(10,-20) | 3 | =JS.ADDNUMBERS(10,20,30,40) | 4 | =JS.ADDNUMBERS(10,20,30,40,TRUE,FALSE) | 5 | =JS.ADDNUMBERS(10,20,30,40,"some text") |
|
1 - What is the sum of the numbers 10 and 20.
2 - What is the sum of the numbers 10 and -20.
3 - What is the sum of the numbers 10, 20, 30 and 40.
4 - What is the sum of the numbers 10, 20, 30 and 40 ignoring any text arguments.