title: EXCEL Summing values YTD based on Criteria (Offset Index Match)
body: <p>Let's say...</p>
  
  <ol>
  <li>I have Jan - Dec data, say columns B : K.  </li>
  <li>Then I have the row labels in column A (Sales, COGS, Travel Expenses, etc...). </li>
  <li>Then on a summary screen, I have a data validation list where the user can choose the month for a Year-to-Date calculation.</li>
  </ol>
  
  <p>I swore I've been able to calculate YTD based off a data validation list in the past using SUMIF(Column A, (Criteria), Offset (Jan) : Index(match) the column # based off of the month selection)</p>
  
  <p>So Mar would move the range from Jan to Mar, and so on.</p>