ADDNUMBERS

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 logical value arguments.
5 - What is the sum of the numbers 10, 20, 30 and 40 ignoring any text arguments.



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