Thanks for the replies. Both solutions work in my attached example, but i realize that there are additional subtle constraints (not mentioned in my example book) that i didn't pick up on before.
Richard - i unfortunately cannot sort my list so i don't think this method will work for me, although it works perfectly in the example workbook.
kvs - this solution is very easy to follow and worked great. However, my two lists are in separate workbooks so the sumif function won't work as I don't want to have both workbooks open. I tried replacing the sumif with sumproduct, however it did not work. This is what i tried:
Any ways to get around this?
Thanks!
Bookmarks