ADDNUMBERS(number1 [,number2] [..])

Returns the sum of a group of numbers.

number1The 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) = 30
2=JS.ADDNUMBERS(10,-20) = -10
3=JS.ADDNUMBERS(10,20,30,40) = 100
4=JS.ADDNUMBERS(10,20,30,40,TRUE,FALSE) = 100
5=JS.ADDNUMBERS(10,20,30,40,"some text") = 100

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.


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext