## Excel SUM based on Partial Text Match (SUMIFS with wildcards)

Excel SUM based on Partial Text Match (SUMIFS with Wildcards) Learn how to SUM values in Excel based on a partial text match. This is great for cases when you need to sum a column based on "criteria contains" a specific value or

## Excel WORKDAY & NETWORKDAYS Functions: Exclude Weekends and Holidays

Excel's workday function is great when you need to calculate an end date based on a given number of working days - which means you need to exclude weekends and holidays. Some examples are: creating a project timeline creating a reporting timetable Excel's standard

## Excel SumIFS – Sum Alternate Columns Based on Criteria and on Header

How to SUM Different Columns based on Header? Excel's SUMIFS function makes it easy to sum columns based on different criteria. But how can you use the SUMIFS function to not just sum based on criteria, but also sum different columns based on the column

## Excel INDIRECT Function

Lookup Values in Different Sheets / Excel Tabs Excel INDIRECT Function The INDIRECT() function comes very handy when need to feed different ranges to certain formulas. It is most useful when you want to refer to tables that are found in different

## Excel Arrays: Count Unique Items with MMULT Function (Part 2/3)

You'll learn all about the Amazing MMULT Function in this Lecture! In Part 2 we will create an Excel Array Formula using SUMPRODUCT and MMULT. In this lecture I will show you how you can use Excel's Matrix Multiplication formula, MMULT function to solve

## 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3)

You'll learn 3 of them in this video! Learn Excel Array formulas by going through the example While I solve this problem, I also explain how array formulas work in Excel. They can be difficult to get the hang of. This video shows you how

## Excel OFFSET Function for Dynamic Calculations

Do you want to create formulas that "move" with your raw data set? That's when you need to use Excel's OFFSET function. OFFSET is a great formula whenever you have dynamic ranges involved. Some examples are: Calculating the average of the last three months when