Count cells based on multiple criteria

[mhartman09]

I've been working on this for a while now and can't figure out how to get the desired result. I'll try to explain as best I can....<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I've got a spreadsheet used to track items given out by our salesmen. Row 1 contains column headers, column A lists the sales reps and column C lists items given out to certain customers. Here's a screenshot of a simplified version of my information:
<o></o>
<o></o>
<o></o>
<o>

</o>
<o></o>
<o>On a separate tab I'm trying to get totals broken down by sales rep and item type as shown:</o>
<o></o>
<o></o>
<o>

</o>
<o></o>
<o></o>
<o>I don't know what formula to use to calculate a total using two columns of criteria. I'm really stumped considering the "Items" column contains multiple items. I'd appreciate any help anyone can offer.</o>

 

[mhartman09]

I'm currently using this formula =SUMPRODUCT((ISNUMBER(SEARCH(J$2,Sheet1!$F:$F)))*(ISNUMBER(SEARCH($B3,Sheet1!$J:$J)))

This formula finds each occurrence where both a particular salesman (J2 is the cell containing the salesman name) is giving out a particular gift (B3 is the cell containing the name of the gift). The column on Sheet1 containing gifts (column J) sometimes has more than one gift listed in a cell. This formula is counting every occurrence, including those with multiple gifts in the same cell.

Would the =COUNTIFS formula be able to count out the gifts in cells containing more than just one gift? I was under the impression that formula would only count the cells in the gift column (column J) containing only an exact match, meaning just a single gift listed.

 

[mhartman09]

Nevermind, I just realized the last string in your formula would accomplish this. Thanks so very much!!