title: Excel SUMIFS Formula
body: <p>I am using the Excel SUMIFS formulas to look for certain item numbers and add that value to the sum. The issue I am having is that many of our item numbers are very close to each other, i.e. 52000135890001 &amp; 52000135890002. </p>
  
  <p>The issue I am having is that the SUMIFS function seems to see these two items as the same value, and is suming them together. I want them added separately, as to us, they are essentially two different items.</p>
  
  <p>I have tried changing the data type for the item numbers to every possible option but the formulas continues to group these together when performing the function.</p>
  
  <p>Does anyone have any ideas how I can still use the SUMIFS formula but somehow tell it to see these two items as different, instead of adding them together under the same criteria?</p>
  
  <p>I am at a loss and losing my mind so any advice would be beyond helpful!</p>
  
  <p>Kyle</p>