title: Different result in Cell and Name Manager with same formula
body: <p>My formula is:</p>
  
  <pre><code>=SUMPRODUCT(MAX((OFFSET(sheet1!$A$1,ROW(sheet1!dynamic_cell_anchor),0,1,1000)&lt;&gt;"")*COLUMN(OFFSET(sheet1!$A$1,ROW(sheet1!dynamic_cell_anchor),0,1,1000))))
  </code></pre>
  
  <p>which can directly return the right result(the largest non-blank column number in that range) in <strong>CELL</strong>. </p>
  
  <p>BUT when this same formula was firstly defined in <strong>Name Manager</strong> then be loaded by its name in <strong>CELL</strong>, it would show as <code>#VALUE!</code> in <strong>CELL</strong>.</p>
  
  <hr>
  
  <p>I checked both by <strong>Evaluate Formula</strong>, They show different middle step:</p>
  
  <p>Directly in <strong>CELL</strong>,</p>
  
  <pre><code>SUMPRODUCT(MAX((OFFSET(sheet1!$A$1,30,0,1,1000)&lt;&gt;"")*COLUMN(OFFSET(sheet1!$A$1,ROW(sheet1!dynamic_cell_anchor),0,1,1000))))
  </code></pre>
  
  <p>Defined in <strong>Name Manager</strong> firstly,</p>
  
  <pre><code>SUMPRODUCT(MAX((OFFSET(sheet1!$A$1,{30},0,1,1000)&lt;&gt;"")*COLUMN(OFFSET(sheet1!$A$1,ROW(sheet1!dynamic_cell_anchor),0,1,1000))))
  </code></pre>
  
  <p>Obviously, a pair of curly brackets affects the result.</p>
  
  <p>Buy why?  and How can this be solved?  (I prefer to define it in Name Manager.)</p>