copy an array formula

  • Thread starter Thread starter JR573PUTT
  • Start date Start date
J

JR573PUTT

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?
 
You've got replies to your other posts.
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy array formula 2
Excel VBA help: Text file formatting 19
Copy Formula's 2
VLOOKUP on external file 2
Copy Formula That References Another Sheet 9
Programmatically copying array formulas 3
Manipulating Formula 3
copying cells from one file to another file 4

Back
Top