Totals from Two Criteria: Sales Amount and Sales Agent Name

[Scwotty]

Good Evening!

I've been having fun with the sumproduct function. Now i don't think it'll work with what I want to do.

I ask in full humility, and I'm hoping that you could recommend some direction. In my sample, there is a dollar amount in cell G8. It would help a ton if I could get that to automatically pull from Sheet 2 (Products Sold by Rep Report). The tricky part that I can't figure out is to show a summed dollar amount for Sales1 (which is he criteria to compare against).

I'm actually going to roam the site to see if the answer is here somewhere. If you beat me to it though, then no hard feelings!

Scwotty