title: How to write formula to display how many times one word is present in a row in ratio?
body: <p>I need to calculate a ratio of words presence. I have simple excel row with 7 values, and I have to answer the following question:</p>
  
  <ol>
  <li>According to the info in your table, which value has the highest ratio? What is the ratio?</li>
  </ol>
  
  <p>These are the values. I guess there might be 2 formulas, where in answer:</p>
  
  <p>The [value which has the highest ratio - calc formula] has the highest ratio, and the ratio is [value from the formula which calculates the ratio] and it should be 3 out of 7.</p>
  
  <p>Screenshot:<br>
  <img src="https://i.stack.imgur.com/G287M.png" alt=""></p>
  
  <p>This is what I've come up with so far:</p>
  
  <p>solution for first problem:
  <img src="https://i.stack.imgur.com/6LWl0.png" alt=""></p>