title: Excel ran out of resources while attempting to calculate one or more formulas
body: <p>I have a workbook to do 'smart'-graphs on my expenses. It's been running for a year and there are now a lot of graphs and expenses. Excel now throws an out-of-resources error whenever I change anything or open the workbook. Thing is, I have <em>lots</em> of resources and its not using hardly any of them.</p>
  
  <pre><code>Win8 64bit w/ 8 core CPU and 32GB of ram
  Office 2013 64bit
  </code></pre>
  
  <p>I have 2 sheets, the first sheet called <em>Expenses</em> has 3 columns [Date,Description,Amount] and about 1500 rows of data. The second sheet has a LOT (500 or so) of formulas that are all the same and aim to do "Sum all expenses between date X and Y where description matches -some needle-". The formula I have is this:</p>
  
  <pre><code>=
  ABS(
      SUMPRODUCT(
          --(Expenses!A:A &gt;= DATE(2011,12,1)), 
          --(Expenses!A:A &lt; DATE(2012,1,1)), 
          --(ISNUMBER(FIND(C50,Expenses!B:B))),
          Expenses!C:C
      )
  )
  </code></pre>
  
  <p>Can I give Excel more resources? (I'm happy for it to use all my ram, and chug my CPU for a few minutes).</p>
  
  <p>Is there a more efficient way I can do this formula?</p>
  
  <p>I understand that this formula is creating a large grid and masking my expenses list with it, and that for each formula this grid has to get created. Should I create a macro to do this more efficiently instead? If I had a macro, I would want to call it from a cell somehow like </p>
  
  <pre><code>=sumExpenses(&lt;startDate&gt;, &lt;endDate&gt;, &lt;needle&gt;)
  </code></pre>
  
  <p>Is that possible?</p>
  
  <p>Thanks.</p>