Problem:

Columns B & C list the prices and categories of various items sold.
Column A contains the ID of the salesperson who sold each item.
The following formula was created to count the number of \"A\" category items that were sold by salesperson \"1\".
=SUMPRODUCT((A2:A9=1)*(B2:C9=\"A\"))
We want to modify the formula so that it calculates the sum of the prices of all items meeting the above criteria.

Solution:

To cause the SUMPRODUCT formula to sum the values from a range instead of counting them, add another argument to the SUMPRODUCT formula that contains the range to sum (cells C2:C9):
=SUMPRODUCT((A2:A9=1)*(B2:B9=\"A\")*C2:C9)