software

How do you copy an array formula that references another sheet:

=sumif(sheet1!a:a)

from one file to another file without the original file extension:

=sumif(c:/'file1'.sheet1!a:A)

The files are shared so I assume I will have to unshare the files?

The formula is commited with ctrl, shift, enter?--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: www.excelforum.com/member.php...oamp;userid=31587
View this thread: www.excelforum.com/showthread...hreadid=513352
Is this possible?--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: www.excelforum.com/member.php...oamp;userid=31587
View this thread: www.excelforum.com/showthread...hreadid=513352You have another suggestion at your original thread.

JR573PUTT wrote:
gt;
gt; How do you copy an array formula that references another sheet:
gt;
gt; =sumif(sheet1!a:a)
gt;
gt; from one file to another file without the original file extension:
gt;
gt; =sumif(c:/'file1'.sheet1!a:A)
gt;
gt; The files are shared so I assume I will have to unshare the files?
gt;
gt; The formula is commited with ctrl, shift, enter?
gt;
gt; --
gt; JR573PUTT
gt; ------------------------------------------------------------------------
gt; JR573PUTT's Profile: www.excelforum.com/member.php...oamp;userid=31587
gt; View this thread: www.excelforum.com/showthread...hreadid=513352

--

Dave Peterson