VBA Sumproduct

[helpexcel]

Hi,

I was going to write code that put this formula in Columns D to the last Column.

=SUMPRODUCT((Sheet1!$A$3:$A$1000=Sheet2!$A3)+0,(Sheet1!$B$3:$B$1000=Sheet2!A$2)+0,(Sheet1!$C$3:$C$1000)+0)

How do I make this portion dynamic? Sheet1!$A$3:$A$1314
Is there code i can use instead of putting this formula in each row?

 

[helpexcel]

It's not practical in this situation, because the pivot table doesn't know there are duplicates and it throws the numbers off.