A
1 10
2 {1,2}

=SUM(A1:A2)
returns 11.

Is there any formula that returns 10 + 1 + 2 = 13?


Thanks!

How many elements in the array constant and how many digits can appear in each element. Is the array constant entered as a formula or as text?

As a formula.

Perhaps like the attached.

Attached Files

SumArrayConstant.xlsm (10.3 KB, 11 views)

First now I see now that you use Excel 2010 which did not have the function FORMULATEXT so you can't use my file.

I however you are very interested it may be possible to replace the FORMULATEXT function with a user defined function. Let me hear if you are interested.

@xor
Yes, a user-defined function sounds very interesting to me. Could you tell me a bit more? Thanks!

See the attached.

Attached Files

SumArrayConstant_2.xlsm (15.2 KB, 10 views)

@xor

Thanks. Studying it.