Here is my formula:

=SUMPRODUCT(('5-1'!$B$2:$B$1000="John Doe")&('5-1'!$D$2:$D$1000="Product
One")&('5-1'!$D$2:$D$1000="Product Two")*('5-1'!$G$2:$G$1000)).

The addition is off, the total should only be 13 but is counting 43.

Second, when I change the range from G2:G1000 to what it should be
G2:G10000, it gives me a #value error message.

What am I missing?

Thank you