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