Hi vmath,

Welcome to ExcelFox !!

do the following

1. Select Product range, copy and paste in I1
2. Select SalesPerson range, copy and paste in J1

Select I1:J25, goto Data > Remove Duplicates

In K2 and copied down,

=SUMIFS($B$2:$B$25,$A$2:$A$25,I2,$D$2:$D$25,J2)

Hope this helps!