title: Sum of Values with Strings
body: <p>I have multiple columns that contain a sample information as listed below:</p>
  
  <pre><code>  A  |  B  |  C  |  D
  ------------------------
   23R | 12C |  4D | 35R
   12C | 76T | 14T | 19D
   32C | 56D | 14R | 68D
   ... | ... | ... | ...
   etc | etc | etc | etc
  </code></pre>
  
  <p>From the whole table (without creating another column), I would like to sum up all the values that contain the letter "R". Given the example table above, the number should be: 72. I've tried a multitude of different approaches:</p>
  
  <ul>
  <li>Doing a straight sum will yield "0" (as expected)</li>
  <li>Tried splitting the letter from the number with a LEFT/RIGHT/LEN combination, but that required another column</li>
  <li>Using SUMIF will only work with numbered ranges (unless someone can show me to apply a function beforehand without an additional column)</li>
  <li>SUMPRODUCT did not help</li>
  <li>Looked into vlookup/hlookup. Didn't yield any desired results</li>
  </ul>
  
  <p>How can I achieve this without any additional columns? Cells can also be blank, and I would like to handle them as zeros if possible.</p>