Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referencing Literal Arrays
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 "Vic Sowers" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
How to use linest with variably sized data arrays? | Excel Worksheet Functions | |||
How do I turn off relative cell referencing in excel? | New Users to Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Comparing Arrays | Excel Worksheet Functions |