title: Excel SUMIFS over a range of number formatted as text
body: <p>I am currently working on an Excel Sheet with thousands of entries.</p>
  
  <p>In one of the columns all the numbers are stored as text. I want to make a <code>SUMIFS</code> over those entries, but it does not seem no work because of the wrong formatting. Is there any way to calculate my results without changing the original data?</p>
  
  <p>Thanks</p>