Re: copy array formula

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
Date: Thu, 16 Feb 2006 15:56:22 -0600

Why all the posts to all the different newsgroups?

JR573PUTT wrote:

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

=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: http://www.excelforum.com/member.php?action=getinfo&userid=31587
View this thread: http://www.excelforum.com/showthread.php?threadid=513369

--

Dave Peterson
.

Follow-Ups:
- Re: copy array formula
  - From: JR573PUTT

References:
- copy array formula
  - From: JR573PUTT

Prev by Date: Re: replacing #N/A values with zero values
Next by Date: Re: Comparing columns in 2 different worksheets, IF Function
Previous by thread: copy array formula
Next by thread: Re: copy array formula
Index(es):
- Date
- Thread