title: SUMIF formula does not work if the criteria range cells contain formulas instead of just values
body: <p>I have a time tracker and trying to count time spent in a given week using SUMIFS.</p>
  
  <p>The week column is a formula that gets the week number from the date, and not a value by itself, and that seems to be tripping up the SUMIFS calculation, and it just returns SUM of zero. If I replace the formula with a written week number, it works.</p>
  
  <p>Is there a way to force SUMIFS to work with the formula, or make it see the value of the cell instead of the formula?</p>
  
  <pre><code>A B C D
  wk48 johnny 29-11-18 misc 10
  wk48 johnny 29-11-18 inbound 130
  wk48 johnny 29-11-18 meeting 30
  </code></pre>
  
  <p>Column A is =WEEKNUM(C,2).</p>
  
  <p>My SUMIFS formula is =SUMIFS(D:D,A:A,"wk48"), but like I said, it only returns zero. If I change the data in column A to be just text instead of getting the week number by formula, it works just fine.</p>
  
  <p>(I'm using SUMIFS instead of just SUMIF because I want to add other criteria as well, but for now I'm trying to get the individual criteria working before combining them together, and I'm stuck on this one.)</p>
  
  <p>Any ideas? Thanks.</p>