title: excel counting + matching 3 columns
body: <p>I have a log where I have two columns (H&amp;G) where I have sales people's names inputted for each row. Column I lists the row as belonging to one of three categories ("name1" "name2" or "name3").</p>
  
  <p>On the next sheet in the book I have tabulations for counting how many times each person's name appears, but what I'd like to do is cross reference that with how many they appear next to each of the categories.</p>
  
  <p>ie I currently can tell that Steve has 6 deals. But what I'd like to know is that Steve has 4 of name1 and 1 each of name2</p>
  
  <p>edit:
  So I think I've not been clear on what I'm searching for: I am trying to sum the number of times a salesperson's name appears in columns F or G that also have a string in column H.</p>
  
  <p>ie: Steve's name appears 13 times, but only 8 of those are on rows that have Phone</p>