title: EXCEL - SUM column if date matches TODAY()
body: <p>I've tried using SUMIF to obtain my results but it doesn't work properly. </p>
  
  <p>I have a row of dates (XX/XX/XXXX format) and I would like to check this row for the current date. </p>
  
  <p>If the row contains the current date, then I would like to sum the total of that column and row 5-20. </p>
  
  <p>For example - today is 10/13/2016. I would like to search for TODAY() in a certain row (Row 1 for example), and if TODAY() is found, then total this column from row 1 down to row 3. </p>
  
  <pre><code>      --A--      --B--
     10/13/2016   10/14/16
  1     50           10
  2     10            4
  3     5             6
  </code></pre>
  
  <p>The result should be 65 only IF the date matches TODAY(). </p>
  
  <p>I've also checked on giving the column letter based on the date but with no luck. </p>
  
  <p>Any tips are appeciated! Thank you. </p>