title: Sumifs return #NA when summing a column of formulas
body: <p>I have a column (L) of data that is calculated simply =N#*O#/1000. 
  In another tab I have another column where I have a sumifs </p>
  
  <pre><code>=SUMIFS('SpX_raw'!$L$2:$L$4253,'SpX_raw'!$E$2:$E$4253,LR!$B4,'SpX_raw'!$F$2:$F$4253,LR!$C4). 
  </code></pre>
  
  <p>I know everything is correct in this formula because when I have another column of data where I just paste in the data it works but it returns #NA when I try it on this column with formulas. How can I get the sumifs to work as I intend on this calculated column?</p>