title: Excel - SUMIF INDEX and MATCH
body: <p>I'm stuck with a sumif formula. I think if I used some mix of index and match I could get it to work but I've been unable to do so for the past hour!</p>
  
  <p>I need to sum from a table of numbers depending on the house number and 2 dates. For example, I need to sum the numbers for house 1 between dates 08-05-17 and 13-05-17.</p>
  
  <p>My previous experience with index and match is that I've only every used it to get a single specific digit. </p>
  
  <p><a href="https://i.stack.imgur.com/JKjtZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JKjtZ.png" alt="What I&#39;m trying to sum"></a></p>
  
  <p><a href="https://i.stack.imgur.com/xolFT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xolFT.png" alt="Where the sum should go"></a></p>