title: SUMPRODUCT ignore row if blank?
body: <p>I have the following results excel doc:</p>
  
  <pre><code>CAR|CLASS|CLASS FINISH POSITION|
  1  |5    |1                    |
  2  |1    |1                    |
  3  |2    |2                    |
  4  |     |                     |
  5  |3    |3                    |
  6  |5    |2                    |
  7  |     |                     |
  8  |2    |5                    |
  9  |5    |                     |
  10 |5    |8                    |
  </code></pre>
  
  <p>I am trying to calculate their CHAMP CLASS POSITION where the results should look like this</p>
  
  <pre><code>CAR|CLASS|CLASS FINISH POSITION|CHAMP CLASS POSITION
  1  |5    |1                    |1
  2  |1    |1                    |1
  3  |2    |2                    |1
  4  |     |                     |
  5  |3    |3                    |1
  6  |5    |2                    |2
  7  |     |                     |
  8  |2    |5                    |2
  9  |5    |                     |
  10 |5    |8                    |3
  </code></pre>
  
  <p>with this formula: </p>
  
  <pre><code>=IF(C2&gt;0,SUMPRODUCT((B2=$B$2:$B$28)*(C2&gt;$C$2:$C$28))+1,"")
  </code></pre>
  
  <p>I end up with the CHAMP CLASS POSITION like this:</p>
  
  <pre><code>CAR|CLASS|CLASS FINISH POSITION|CHAMP CLASS POSITION
  1  |5    |1                    |2
  2  |1    |1                    |1
  3  |2    |2                    |1
  4  |     |                     |
  5  |3    |3                    |1
  6  |5    |2                    |3
  7  |     |                     |
  8  |2    |5                    |2
  9  |5    |                     |
  10 |5    |8                    |4
  </code></pre>
  
  <p>because car 9 in class 5 did not finish and has no class result it bumps all class 5 positions by 1.</p>
  
  <p>Is there a way to tweak the formula to exclude any results where class finish position is BLANK?</p>
  
  <p>Obviously I can delete the class cell for car 9 for it to work, but this sheet would be used for multiple events.</p>