hi,
i am using this formula to get value from another workbook
this is working properly if workbook is open,
Please Login or Register to view this content.
if i close 3.9.19.xlsb as referenced in formula then this formula giving an error #value
hope some one will help
thanx
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
COUNTIFS will not work with a closed workbook. You have to use SUMPRODUCT instead. Since I can't see what you are doing, I can't really help any further. Can you mock up two sheets to show me?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
ok, thanks for the replya Mod.
i have two workbook at my desktop first one's name is 3.9.19 and second one'e name is 4.9.19Please Login or Register to view this content.
i want to count the value according to three criteria, in workbook name 3.9.19
Untitled.jpg
Without testing
=sumproduct(('[3.9.19.xlsx]OL BC'!$B$10:$B$1000=G6)*('[3.9.19.xlsx]OL BC'!$H$10:$H$1000>=O6)*('[3.9.19.xlsx]OL BC'!$H$10:$H$1000<149))
SuperOriginally Posted by davsth
its working properly
thanks #davsth
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks