Vic Sowers wrote:
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.
|