Well I got the answer. I did some research and found that evaluate would be the best route to go towards getting sumproduct to work with this. I know it would take sumproduct, but wasn't sure how to quite work that in for the evaluate. I got some assistance in writing that portion and got this working. Here is the code, but again this is based off what you asked for, which does not match the results you provided. And to give credit where credit is due, Dave Peterson was able to help me with implementing the sumproduct.
Bookmarks