title: How to Exclude 0 values from my =Count formula?
body: <p>DESPERATE for any help :-)
  I need to exclude 0 values from my =COUNT excel formula in order to get an automated frequency value feeding another formula in my model.</p>
  
  <p>Actual Base Formula:
  =COUNT(J10,J11,J12,N10,N11,N12,J14,J15,J16,N14,N15,N16)</p>
  
  <p>I am trying to get the formula to NOT count when any of these cells have O values. For instance, if J10 is greater than 0, include it in the count.</p>
  
  <p>I have tried several different "IF" statements, but am failing miserably!</p>
  
  <p>I basically need to dummy proof this by automating it versus having users simply count the cells with values and enter the number into the frequency field for my score calculator. Thanks so much for any help!!</p>