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 readingTag Archives: Advanced Excel
SUMIFS/INDEX/MATCH VS. SUMPRODUCT Functions: HR Data Example
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how we can use SUMIFS/INDEX/MATCH and SUMPRODUCT differently to achieve the same result. Let’s get started In the captions below, we have HR Salary Data in Dynamic SUMPRODUCT and Dynamic SUMIFS sheet Note, we have list data validation in cells M2 (List of unique department), and […]
Continue reading
Permanently Tabulate Pivot Table Report & Repeat All Item Labels
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to permanently tabulate Pivot Table report and how to repeats all item labels. Let’s get started. In the caption below, we have a Pivot Table report showing Sum of Total by States and Account Manager. Notice that, we have Row Labels in cell A3 where the […]
Continue reading