|
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 |
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 |
| All times are GMT +1. The time now is 05:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com