| 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 |
| 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 | |||
Threaded Mode
