title: Excel: Better Percentage Ranges
body: <p>I am attempting to write up some tables which automatically populate with a percentage range based on if there are any contents, (and how many contents overall).</p>
  
  <p>Picture is what I am looking for, if you enter info in the blank boxes it automatically calculates the new ranges, and vice-versa by deleting any.</p>
  
  <p><img src="https://i.stack.imgur.com/vgmXs.png" alt="Percentage Ranges">
  .</p>
  
  <p>I already have a working code, but it feels clunky and I'm worried that if I had a whole datasheet full of this that it will more than likely crash.</p>
  
  <pre><code>=IF(NOT(ISBLANK(C84)),
  (
  TEXT(COUNTA(B84:$B84)/COUNTA($B84:$N84)+0.01,"0%")
  )&amp;"-"&amp; TEXT(
  COUNTA(B84:$B84)/COUNTA($B84:$N84)+1/COUNTA($B84:$N84),"0%"),"-")
  </code></pre>
  
  <p>Any suggestions on trimming this?</p>