I am having problems evaluating a sumproduct function. I have created 6 arrays which I use in the sumproduct function but the evaluation turns up "empty" ("formula2" is empty). 5 out of the 6 arrays are logic vectors and the 6th contains values. All the arrays are the same length and contain no blanks or errors.
Any help would be appreciated.
Please Login or Register to view this content.
Hi,
You cannot pass an array to a formula string in that way, but you should be able to pass the arrays to the worksheetfunction
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks