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 […]
Continue readingTag Archives: SUMPRODUCT
Advanced: SUMPRODUCT with MID, LEFT & FIND Text Functions
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use advanced method to sum values using combination of MID, LEFT & FIND Text Functions. Let’s get started Sample Data In the caption below, we have sample data We want calculate the Total for Account Manager whose First Name is David and Country of operation is Nigeria. Based […]
Continue reading