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