Quote Originally Posted by mdmackillop View Post
Can you post a sample workbook?
Alas, I am uncomfortable doing that as there is nothing in this workbook but confidential information. I am able to get around the issue by revising my formula to include two sumproduct statements rather than trying to combine them into one. I just left the thread as unsolved on the chance that something might jump out at someone. I'll mark the post as solved. Thanks.