Dave Bruns

SUMIFS Function

The SUMIFS function sums numbers in Excel when they meet one or more specific conditions. SUMIFS is one of Excel's most widely used functions, and you will see it in all kinds of spreadsheets that calculate conditional sums based on dates, text, or numbers. Although a common function, ...Read more

Read more about SUMIFS Function

Statistical

COUNTIFS Function

The COUNTIFS function counts cells in a range when they meet one or more specific conditions. COUNTIFS is one of Excel's most widely used functions, and you find it in all kinds of spreadsheets that perform conditional counts based on dates, text, or numbers. Although common, COUNTIFS has a...Read more

Read more about COUNTIFS Function

How to pick names out of a hat with Excel

In this video we look at how to simulate a random drawing to pick winners in a contest with Excel using the RAND and RANK functions together.

Read more about How to pick names out of a hat with Excel

How to find and highlight formulas

In this video, we show you three ways to find formulas in a worksheet, including a tricky way to use conditional formatting and a named formula to highlight formulas. ...

Read more about How to find and highlight formulas

How to use concatenation to clarify assumptions

In this video we show how to use the TEXT function to call out assumptions in a model. You can use the same approach to highlight assumptions in any spreadsheet.

Read more about How to use concatenation to clarify assumptions

How to change case with UPPER LOWER and PROPER

In this video we show how to use the UPPER, LOWER, and PROPER functions to transform case with a formula.

Read more about How to change case with UPPER LOWER and PROPER

How to clean text with CLEAN and TRIM

This video shows you how to use two text functions, CLEAN and TRIM, to strip extra spaces and remove line breaks from text.

Read more about How to clean text with CLEAN and TRIM

How to concatenate with line breaks

In this video we demo how to join different values together in one cell with line breaks. This also includes a clever way to add spaces and commas without using double quotes.

Read more about How to concatenate with line breaks

How to count characters with the LEN function

In this video we look at how to use the LEN function to calculate the number of characters in a text string. LEN is a surprisingly useful function that appears in many formulas.