title: SUMIFs multiple criteria is not working consitently
body: <p>I am using Google Sheets with the spreadsheet shown below.</p>
  <p>I want to Sum the 'Amount' column
  IF the Key in column J == the key in column B
  AND The Assigned person == the actual person.</p>
  <p>So, where the key is 2, we'd have a subset of 7 items. From that the assigned person is Sally and four entries match, our total would therefore be the sum of those matching values which are 20, 10, 2, 4 giving a sum of 36.</p>
  <p>In K3, we can correctly see the sum of 36.</p>
  <p>The formulae I used in that cell is:
  =SUMIFS(H:H,B:B,J3,G:G,D:D)</p>
  <p>The cell below has the formulae:
  =SUMIFS(H:H,B:B,J4,G:G,D:D)</p>
  <p>So, that should, I believe sum the values 3,8 and 4 since the key (3) in column J matches three items in column B. In each case Mike is the assigned and actual person, which means we should be summing 3, 8 and 4. However, the value as you can see is 0.</p>
  <p>Any ideas what I'm doing wrong, please?</p>
  <p><a href="https://i.stack.imgur.com/Mc7EZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Mc7EZ.png" alt="enter image description here" /></a></p>