Hi,
I am using this formula in worksheet A in file A that reads from worksheet B from file B.
=SUMPRODUCT(([Kev.xls]Sheet1!$D$2:$D$5000=E11)*([Kev.xls]Sheet1!$B$2:$B$5000=$J$9),[Kev.xls]Sheet1!$L$2:$L$5000)
When I close both files and open worksheet A, it returns as #NA.
If I open worksheet B, then it is fine.
How can I get this formula in worksheet A to work without having to open worksheet B? Thanks.
Try converting to Sum(IF())...
this must be confirmed with CTRL+SHIFT+ENTER not just ENTER
Please Login or Register to view this content.
But Sumproduct() should be okay with closed workbooks.
Last edited by NBVC; 05-13-2008 at 03:31 PM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi,
More info on SUMPRODUCT if you need it
http://www.bettersolutions.com/excel...O231331611.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks