Running Total using SUMIF Function

Welcome to Excel Jet Consult blog post. In this tutorial, we gonna learn how to use the SUMIF Function to calculate Running Total in Excel. Let’s dive in. Video Sample Data¬† In the caption below, we have product catalog dataset we are going to use Running Total Calculation In cell K2, execute the formula: =SUMIF($A$2:A2,A2,$J$2:$J$1992) In the above formula, we […]

Continue reading

Generate Email Addresses in Microsoft Excel [Six Examples + Power Query]

Welcome to Excel Jet Consult blog post. In this Microsoft Excel blog post, I will demo how to generate Email Addresses using different examples including Power Query. Video Sample Data In the caption below, we have sample HR dataset. We want to generate email addresses for each of the Employees using Six different methods. Ampersand First, we are going to […]

Continue reading

OFFSET Inside SUMIFS with Multiple Criteria [Single Cell Report]

Welcome to Excel Jet Consult blog post. In this Microsoft Excel tutorial, we will learn how to use the OFFSET function inside SUMIFS to perform multiple criteria calculation inside a single cell. Video Sample data In the screenshot below, we have a Sales Data that is stored as an Excel Tables. Calculation In cell J2, we want to write a […]

Continue reading

Subtotal Across Multiple Columns [Outline Advanced Options Italic]

In this Microsoft Excel tutorial, I demo how to perform Subtotal Across Multiple Columns and how to italicize selected cells using the inconspicuous Outline Advanced Options dialogue box! Let’s get started   Video Sample Data In the screenshot below, we have sales data that spans from Date to Sales Amount. Note that it is impossible to perform Subtotal with dataset […]

Continue reading