You should really be looking to use SUMIFS rather than SUMPRODUCT - it will be significantly more efficient