title: Why would a named range not work?
body: <p>I am having an interesting problem with a pretty simple excel SUMIF statement. The SUMIF uses a named range(represents a single cell only) as its criteria i.e. <code>=SUMIF(A1:A100,*named range*,B1:B100)</code>. For some reason the result of this SUMIF statement doesn't change when the named range value is changed. I fixed the problem by referencing the specific cell, but am wondering why this problem would be occurring. </p>
  
  <p>A few things to mention:</p>
  
  <p>I made sure that cell calculations were automatic.
  Also this sheet was copied into the workbook, but the formulas were added after.</p>
  
  <p>Thanks for the help.</p>