Guys,
im using 2 workbooks and need 2 keep an update of 1 of them the other workbook will be used by another department if they havnt got there work book open my book comes up with #value error is there a way around this i have left 2 test workbooks for examples
Puzzled thanks
You can't use SUMIF/COUNTIF where target is closed... you can use SUM/COUNT Arrays or SUMPRODUCT.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Ok thanks i have just found a link on arrays and sum(if is what i need dont think i will ever get my head around arrays
I would opt for SUMPRODUCT in preference to COUNT(IF or SUM(IF CSE Array as it will be slightly more robust for the end user (ie can be committed with ENTER as normal - no CSE requirement)
eg using your sample file(s)
=SUMPRODUCT(--('C:\your file path\[Test2.xls]22-09-09'!$A$1:$J$3="Test"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks