copy array formula

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?
 
J

JR573PUTT

I thought different people would be in different sites? Just signed on
yesterday, why are you in all the sites? Do you work for Exceltip?

I apologize, I will post only once going forward, unless I post and
realize I did not make sense!
 

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 an array formula 1
Copy Formula's 2
Problem with Sumif formula 5
Copy Formula That References Another Sheet 9
index, match in array setup question 1
sumproduct formula work around 11
SUMIF help 6
SUMIF formula using data from another file 2

Top