ADDNUMBERS

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)
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.


microsoft excel docs

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