Dave Bruns

All values in a range are at least

At the core, this formula uses the COUNTIF function to count any cells that fall below a given value, which is hardcoded as 65 in the formula:

COUNTIF(B5:F5,"<65")

In this part of the formula, COUNTIF will return a positive number if...Read more

Read more about All values in a range are at least

Count

Count numbers by nth digit

In this example, the goal is to count numbers in the range B5:B15 (named data) where the third digit is a specific number, indicated in column D. You might think the COUNTIF function would be a good way to solve this problem. However, for ...Read more

Read more about Count numbers by nth digit

How to create a new table style

In this video, we'll look at how to create and modify your own custom table style...

Read more about How to create a new table style

How to apply a table style

In this video, we'll look at how to apply a table style. Table styles quickly change the look and feel of an Excel Table. ...

Read more about How to apply a table style

Introduction to table styles

In this video, we'll introduce Table Styles. Table styles make it easy to save and apply table formatting...

Read more about Introduction to table styles

Conditional formatting formula in a table

In this video we'll look at how to apply conditional formatting to a table with a formula...

Read more about Conditional formatting formula in a table

How to use Calculated Columns

In this video, we'll look more closely at calculated columns in Excel Tables, a feature to automatically enter and maintain formulas...

Read more about How to use Calculated Columns

Excel Table Options

In this video, we'll look at the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas...

Read more about Excel Table Options

How to add a totals row to a Table

In this video, we'll look at how to add and configure a Total Row to an Excel Table. The Total Row can automatically show summary calculations below a table...