title: How to sum all value based on multiple data input in one cell
body: <p>I have a sheet like this</p>
  
  <pre><code>A       B     C                            D
  Apple   10    Apple Apple Orange Melon     
  Orange  30 
  Melon   50
  </code></pre>
  
  <p>I want D1 to show the sum value based on the value in C1 which is 2 apples, oranges, and Melon (10+10+30+50) = 100</p>
  
  <p>Any advice on what to type in column D1? I assume it will be related to <code>sumif</code>?</p>