In Lake Wobegon, they say that all of the students are above average. Today, we will use the COUNTIF function with a clever twist. The 2nd parameter is constructed by concatanating an operator with the result of another function to see how many students really are above average. Episode 227 will show you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Once someone learns SumIf they soon want to know how to use SumIf with two conditions. Unfortunately, you can not do it with a SumIf. Episode 226 shows you how to use the boolean logic from yesterday's episode to solve the problem.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Use an old boolean logic trick to eliminate the IF function. Today's Episode 225 will lay the groundwork for the super powerful formula in tomorrow's podcast.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

How to use Logical Formulas, along with the AND and OR functions to figure out if the sales reps should get a bonus. Episode 224 will reveal everything about these boolean logic facts.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!