title: SUMPRODUCT Circular error
body: <p>I'm having trouble with a simple excel formula. Here is a basic example :</p>
  
  <p><a href="https://i.stack.imgur.com/s7gkh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s7gkh.png" alt="enter image description here"></a></p>
  
  <p>I'm trying to sum all cells in B4:C7 when column A is not equal to B. If I set this formula in D1 for example this works well. </p>
  
  <p>However If the formula is within the range B4:C7 on a line where column A is equal to B I get a circular error. The problem is there is no way my formula takes its own cell as it is on a line which colA = B. Excel calculates 0 as a result.</p>
  
  <p>I know this example look silly. In my real problem all lines with A in col A won't execute the sumproduct because of various If conditions.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>Here is a more precise example. The second tab displays what is correct. The formula is the same except for the ranges of the sumproduct that start from the line under the current one.</p>
  
  <p>The formula is checking if some actual data was realized on the following month so as to start amortizing the budget after the last realized month.</p>
  
  <p><a href="https://i.stack.imgur.com/hUGay.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hUGay.png" alt="enter image description here"></a></p>