title: Excel SUMIF when it validates that a cell range consists of a word or number (Statement of Accounts calculation)
body: <p>Excel sheet image click -> <a href="https://i.stack.imgur.com/7pK77.png" rel="nofollow noreferrer">Image</a></p>
  
  <p>Hi people, currently I'm trying to make a Statement of Accounts using excel spreadsheet. I need help in creating the formula for the "??" highlighted in red as shown in the picture (Cells F17 and H17). </p>
  
  <p>What i need it to be is that the cell in F17 searches for the strings in the Date column (B6 to B8) and then summing the cells in (E6 and E8) when it sees number "10" in the each of the date column (B6 to B8) as it is for month of October. </p>
  
  <p>Please assist.
  Here is the answer to the above <a href="https://stackoverflow.com/a/47726455/9075574">https://stackoverflow.com/a/47726455/9075574</a></p>
  
  <p>UPDATE:</p>
  
  <p>Hey guys, currently im facing another error which returns a #VALUE in my cells as shown in this <a href="https://i.stack.imgur.com/DrN3z.png" rel="nofollow noreferrer">image</a> after 'beautifying' the template.</p>
  
  <p>This is the code as shown <a href="https://i.stack.imgur.com/Mitri.png" rel="nofollow noreferrer">here</a>.</p>
  
  <p>Any idea why? I tried modifying the code to my needs but it seems like it created more problems. UPDATE: Problem solved and solution is posted below.</p>