Cell value as Array Constants, how to sum them up?

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel
Cell value as Array Constants, how to sum them up?

Prev

Previous Post

Next Post

Next

#1

Old

11-02-2016, 04:29 AM

tinfanide

tinfanide is offline

Cell value as Array Constants, how to sum them up?

Windows 7 64bit Cell value as Array Constants, how to sum them up?

Cell value as Array Constants, how to sum them up?

Office 2010 32bit

Expert

Cell value as Array Constants, how to sum them up?

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
looking to persist and array or something	vthomeschoolmom	Word VBA	1	09-16-2015 02:12 PM
Insertbefore an array? help :(	n00bie-n00b	Word VBA	21	08-21-2014 08:03 PM
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM
Complex array formula	andrei	Excel	9	02-03-2012 03:40 AM
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 AM.