I'm pretty sure that SUMPRODUCT is the solution to my problem here. I'm new to the SUMPRODUCT formula and fully understand it's basics and straight forward usage, however my SUMPRODUCT usage/requirement is a little more complex are I'm struggling with finding the right syntax to make things work...