title: Creating a sum based on a category within a date range
body: <p>I'm trying to make a spreadsheet that I can easily take an export from Mint.com's CSV outputs and get them into my Excel budget.</p>
  
  <p>To do so, I need a way to populate each field within a date range. I'd like to avoid macros if possible (I don't know how to make them).</p>
  
  <p>I'm happy to share my finished .xls with the public!</p>
  
  <p>I've imported Mint.com's data in a manner that has column S for the date (3/30), column V with the cash value that I need to add up, and column X for the spending category. 
  I need to tally each month's spending ($V) by category (column X).</p>
  
  <p>Through research, I devised this (for my January "Gas &amp; Fuel" spending):</p>
  
  <blockquote>
    <p>=SUMIFS($W$2:$W$900, $T$2:$T$900, ">="&amp;W$12, $T$2:$T$900, "&lt;"&amp;(EOMONTH(D$1,0)+1), $Y$2:$Y$900, "="&amp;$B5)</p>
  </blockquote>
  
  <p>However, it required that I reformat my Dates, which is an issue because this would become specific to each year and I would need to change the fields every year. I'd like the document to be usable without adjustment using my spending data from the past and future.</p>
  
  <p>Is there a way to take the year out of the equation? To make that formula above work, I renamed my column from "January" to "1/14".</p>
  
  <p><a href="https://www.dropbox.com/s/hcj42x8ekzd4doh/Screenshot%202014-04-02%2000.19.32.png" rel="nofollow">Here is what the spreadsheet looks like</a></p>
  
  <p>Thanks!</p>