remember one thing while using sumproduct if you are matching for non numeric then match should be non numeric

and when you are taking sum at final instance the column/ row must contain numeric values

regards