Thread: Cell value as Array Constants, how to sum them up?
View Single Post
 
Old 11-02-2016, 04:29 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default Cell value as Array Constants, how to sum them up?
A
1 10
2 {1,2}

=SUM(A1:A2)
returns 11.

Is there any formula that returns 10 + 1 + 2 = 13?
Thanks!
Reply With Quote