Hi Jon,

You do need a sumproduct() formula ...
Feel free to upload a zipped sample of your worksheet for a precise answer ...