Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use what has become my favorite function in Excel – SUMPRODUCT with rarely known Case Sensitive function – EXACT. I was inquisitive minded to discover whether it is possible to sum values based on text. That led me into about 20 minutes of trying to […]