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.
* This function is identical to the built-in SUM function and has been included for comparison purposes.


MORE EXAMPLES

 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

MORE FUNCTIONS
SUMFORMAT returns the sum of all the values that have been formatted with multiple attributes.


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