title: Calculate average if cell is not blank
body: <p>I'm building a scoring spreadsheet that is gradually populated as additional data is received. </p>
  
  <p>I want to create a formula that will give me the running average (that will change as more data is inputted) that is dependent on 2 columns. </p>
  
  <p>Essentially I have 3 columns: Column A has a Report #, Column B the name of an organization, and Column C which has a score.</p>
  
  <p>The formula should calculate an average that does not include blank or zero scores in the calculation but only uses those scores associated with a specific organization.</p>
  
  <p>I've tried the following:</p>
  
  <pre><code>=IF(B2:B100="organization", AVERAGEIF(C2:C100, "&gt;0"))
  </code></pre>
  
  <p>Also:</p>
  
  <pre><code>=IF(B2:B100="organization", IF(C2:C100="","",AVERAGE(C2:C100)
  </code></pre>
  
  <p>In both instances I get a <code>#Value</code> error.</p>
  
  <p>The issue is that the <code>AVERAGE()</code> or <code>AVERAGEIF()</code> function need to target only those scores that meet the B2:B100="organization" criteria</p>