title: Why is Sumproduct formula showing #Value error?
body: <p>I receive a #value error while using the sumproduct formulas.
  The main idea behind this document is to track the actuals on a daily basis using the following conditions:</p>
  
  <ul>
  <li>If the date is equal to the one specified in cell E2</li>
  <li>If the team name found in ranges e18:e46 or e50:e52 are the same as listed in the range C4:C8</li>
  <li>Sum the values found for those specific columns</li>
  </ul>
  
  <p>Added the document for reference <a href="https://www.mediafire.com/file/ztlen237wluzka9/test.xlsx/file" rel="nofollow noreferrer">Excel File</a></p>
  
  <p>I can't figure out what's wrong. Also to be specified that if i manually fill up random values in the table, the formula works.</p>