title: Determine the quantity of unique increasing values within a range
body: <p>I am attempting to write a formula that will identify the number of supplements that I have received on any specific contract.  These numbers should be increasing in value in excess of $100 greater than the previous value and ignoring blank cells.  Ex:</p>
  
  <pre><code> Year            2014  2015  2016  2017  2018   2019     Quantity should be
  Contract #1     $1000 $1001 $3000 $5000  $4000  BLANK            2
  Contract #2     BLANK BLANK $5000 $8000  $8000  $7000            1
  </code></pre>
  
  <p>In this scenario, there were 2 values that meet the requirements</p>
  
  <p>This is my most recent attempt at an equation </p>
  
  <pre><code>=COUNTIF($DF3:$DK3,"&gt;"&amp;DF3+100)+COUNTIF($DF3:DF3,DF3)-1
  </code></pre>
  
  <p>However, it does not account for if there is a reduction in the sale at the end of the project.</p>