title: Dynamical SUMIF command
body: <p>If it is possible, I'd like to create a formula that will allow me the following:</p>
  <p>Formula must be in the entire column or in this example, in the range B1:B5. The formula is based on a condition, that when the total sum of cells from column A is lower D1, than it gives &quot;X&quot;. If the total sum is over D1, then it gives an empty field - &quot;&quot;.</p>
  <p>In this example the total sum of the cells, that are over D1 value is in the first 3 rows, hence the three X-es, and then it stops.</p>
  <p><a href="https://i.stack.imgur.com/LXUNJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LXUNJ.png" alt="Valid XHTML" /></a><br />
  <sub>(source: <a href="http://shrani.si/f/1W/10N/4cuGrhGd/delete.png" rel="nofollow noreferrer">shrani.si</a>)</sub><br />
  .</p>
  <p>I presume it would be possible to do this with multiple SUMIF commands, but does anyone know a smoother solution for this?</p>
  <p>Thanks!</p>