Thread: copy an array formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JR573PUTT[_3_] JR573PUTT[_3_] is offline
external usenet poster
  
Posts: 1
Default copy an array formula

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

Reply With QuoteReply With Quote