title: EXCEL Sum range based on row and column criteria
body: <p>Given the Category table below:</p>
  <p><a href="https://i.stack.imgur.com/aYy1q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aYy1q.png" alt="sample" /></a></p>
  <p>... how can I add all values in a particular category row that are in columns where the date header is &lt;= TODAY() ?</p>
  <p>For example, in cell B2 I want a running total of the values corresponding to the &quot;Internet Bill&quot; row and only columns where today (3/15) is &gt;= the date in the column header. I highlighted these values in red just for the example.</p>
  <p>Here's what I have so far in B2:</p>
  <p><code>=SUM(INDEX($F$2:$J$4,MATCH($A2,$E2,0),MATCH(TODAY(),$F$1:$J$1,1)))</code></p>
  <p>But it's only giving me &quot;$45,&quot; which I understand correlates the greatest date value lesser than 3/15. I just can't get the INDEX formula to return a column_num range filtered by a comparison operator...</p>