Thread: copy an array formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default copy an array formula
You've got replies to your other posts.

JR573PUTT wrote:

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: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=513370



--

Dave Peterson
Reply With QuoteReply With Quote