ajBigNumSumRange function

Description

Returns a BigNumber whose value is the sum of the arguments.

Syntax

ajBigNumSumRange(numbers)

Argument Name	Argument Type	Description
numbers (required)	Range / Array	An array of number in number or string format. It could be cell range or an array string. For example, D1:F1 or {12, "13", 14}

The function will return:

1) Return Value: BigNumber String

2) Return Type: Single Value

Example 1

Provide the number list in array format.

=ajBigNumSumRange({1,"2",3})

The function returns 6.

Example 2

Provide the number list in a range.

=ajBigNumSumRange(A16:C17)

The function returns 22.

Error Scenarios

It will return #VALUE! when missing any required parameter or mismatch parameter type. Besides, system will raise error for below scenario(s).

Error Scenario
Not all elements in numbers can be converted to a number.
Unrecognized array format.