title: Using "INDIRECT" function in the "SUMPRODUCT" formula for True/False Cell Reference
body: <p>This is the formula that I am currently using:</p>
  
  <pre><code>=SUMPRODUCT((INDIRECT("A2"):INDIRECT("A"&amp;(ROW()-1))=A359)*1)
  </code></pre>
  
  <p>It works great, but I would like to use this instead:</p>
  
  <pre><code>=SUMPRODUCT((INDIRECT("A2"):INDIRECT("A"&amp;(ROW()-1))=INDIRECT("A"&amp;(ROW())))*1)
  </code></pre>
  
  <p>Unfortunately I get a <code>#VALUE!</code>.  What am I doing wrong?  Both <code>INDIRECT("A"&amp;ROW(()))</code> and <code>A359</code> return the same value, so I'm not sure why this won't work.</p>
  
  <p>The reason I am not using a simple <code>COUNTIF</code> function is because I stripped my formula of all unnecessary components and only left the part that I am having trouble with (i.e. I need to use the <code>SUMPRODUCT</code> formula and a <code>COUNTIF</code> formula will not work)</p>
  
  <p>Thanks in advance!</p>