title: Right Function between SUMIFS or SUMIF function in Excel
body: <p>I have some alphanumeric data in column A on sheet A. Something like this:-</p>
  
  <pre><code> abcd-1234
  </code></pre>
  
  <p>and so on and some value corresponding to every value in col B.</p>
  
  <p>On another sheet i have 1234 means only the numeric part of this data on sheet B. Now i want to sum the data on col B on Sheet A with matching value in Sheet A. I have tried this so far:-</p>
  
  <pre><code>=SUMIFS(A!$A$1:$A$100,RIGHT(A!$B$2:$B$100,4),$A1)
  </code></pre>
  
  <p>But it is not working. Please help!!</p>