title: How to use SUMIFS function for summing values if criteria range exists in a range?
body: <p>My data:</p>
  
  <pre><code>A   B    C
  a   3    d
  b   1    a
  c   8    e
  d   5    
  </code></pre>
  
  <p>I want to use <code>SUMIFS</code> function, sum range is <code>B1:B4</code>, if the corresponding value in column <code>A</code> exists in column <code>C</code>, sum the values in column <code>B</code>,
  in this case the sum will be <code>3 + 5 = 8</code>
  I tried <code>=SUMIFS(B1:B4,A1:A4, COUNTIF($C$1:$C$3,A1)</code> but I get zero.</p>