Referencing Literal Arrays

[Vic Sowers]

If A1 contains =SUM({1,2,3}) it displays 6 (good!), but
if A2 contains =SUM(B2) and B2 contains ={1,2,3} it displays 1 (bad...).

How can I get the reference to B2 in A2 to treat B2 as an array?

TIA

 

[Aladin Akyurek]

If A1 contains =SUM({1,2,3}) it displays 6 (good!), but
if A2 contains =SUM(B2) and B2 contains ={1,2,3} it displays 1 (bad...).

How can I get the reference to B2 in A2 to treat B2 as an array?

TIA

In B2 with

={1,2,3}

only the topleft item is available.

Not that it's the right thing to do, but if you enter in B2

{1,2,3}

without the = sign, you can have:

=SUM(EVAL(B2))

provided you have EVAL, for example, from the morefunc.xll add-in.

 

[PC]

Don't believe you can store an array in a single cell.

You can definitely store the array in a named formula

Insert/Name/Define

Give it a name and enter the array ={1,2,3}

HTH

PC