View Single Post
  #1   Report Post  
Vic Sowers
 
Posts: n/a
Default 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