title: Subtract values of ranged cells from a cell if ranged cells are not blank
body: <p>First, my apologies for the confusion of this question. The title probably isn't worded very well, but I couldn't think of a better way to ask it. And because I don't know how to ask it simply, I could not find any answers.</p>
  
  <p>I am wondering if there is a way to subtract a value of a cell from another cell if yet another cell is not blank. This is simply done when not using a range using something like:</p>
  
  <pre><code>=if(a1&lt;&gt;"", c1-b1, c1)
  </code></pre>
  
  <p>But I want to check multiple cells in a range. If a cell in that range is not blank, subtract a correlated value from a working total, otherwise subtract nothing. Go to next cell in the range, if that cell is not blank, subtract a correlated value, and so on...</p>
  
  <p>Let's say:</p>
  
  <ul>
  <li>Original value to be subtracted from is c1</li>
  <li>Range of cells to be checked are a1:a10</li>
  <li>Coorelated value to subtract is located in b1:b10</li>
  </ul>
  
  <p>So... in a1:a10, there will be date. If a1 is not blank, subtract b1 from c1. Lets call this value workingValue. Go to a2... if a2 is not blank, subtract b2 from workingValue. Go to a3... if a3 is not blank, subtract b3 from workingvalue, and on down the list. </p>
  
  <p>The final workingValue can go anywhere, but for simplicity, let's put it in C2.</p>
  
  <p>Is this possible with an excel formula (not VB)?</p>