# Formulas

## 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

## 3 Ways to Transpose Excel Data

3 Ways to Transpose Excel Data (Rotate data from Horizontal to Vertical or Vice Versa) Check out 3 ways to Transpose your data in Excel. These are useful when you want to switch the orientation of your data from columns to rows

## VLOOKUP Explained with 2 Practical Examples

VLOOKUP & HLOOKUP for Dynamic Lookups These two functions are easy to write, understand, and they’re a major time-saver for simpler lookups. The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns.

## Return Multiple Match Values in Excel

Lookup 1 Value, Return Many Matches The VLOOKUP and INDEX & MATCH formulas are great for looking up a value in a large data table and returning a result from the adjacent columns. But how can you return multiple results? What if

## Excel SUM Between Dates

How can you sum values between two dates in Excel? What if you wanted the sum for a specific month? And what if you decided to add in multiple criteria to your existing sum? For example get the sum by month AND division AND

## Copy Excel Formulas Without Changing Cell References

Would you like to copy your Excel formulas from one place to another without the cell references changing? Excel default behavior is to adjust the cell references when you copy a cell and paste to another one. You can choose to fix the cell

## Excel IF Formula: Simple to Advanced

Excel IF Formula: Simple to Advanced Including: IF with Multiple Criteria, Nested IF, AND, OR functions The IF() function has an important place amongst the most popular functions in Excel. It performs a simple logical test (is a statement TRUE or FALSE?)

## Reset Week Number Every Month (start from Week # 1 every new month)

WeekDay & WeekNum Functions Explained Excel Reset Week Number Every Month In this tutorial I show you two ways to reset the week number to start from 1 at the beginning of every month. 1st case: We use Excel's WEEKNUM function to

## Lookup values across multiple worksheets in Excel

Lookup values across multiple worksheets: VLOOKUP & INDEX MATCH in Excel In Excel, it’s relatively easy to lookup values in one specific tab. But how do you lookup values in multiple tabs using only one formula? In this tutorial, I'll show you

## Complex Lookup: Find Header

Find Header based on Lookup Criteria in Matrix (Unique matrix values) - scroll down for non-unique method  In this tutorial I show you the answer to one of the questions that was asked some time ago on the Mr. Excel message board (the sample