This works! Thank you.

Can you pls explain what do you mean by this?

I can't think of way to code that sumproduct formula efficiently. I'd probably approach it by assigning the formula it to a cell and then reading the cell value.