VBA Sumproduct Variable Query

Hi,

I have another query on Subproduct, so far the help I've had has been excellent so hopefully this will be the last on this area....


I have the code;

Please Login or Register  to view this content.

I have tried to use the variable within the Sumproduct code, so instead of the code highlighted above, I want to use the following;

Please Login or Register  to view this content.

but I get a "Run-time error 13 .... Type mismatch" error MSG. Using the variable works in the 'AverageIfs' code.

Please could someone point me in the right direction. Thanks.