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!

As you learned this week, SUMIF and COUNTIF are the coolest functions, but as you try to use them for something that is just a tiny bit more powerful, they fail. What happens when you have to SUMIF based on two conditions? You will have to turn to a really complicated kind of formula called an array formula. Luckily, Excel offers an add-in that will help you build these formulas. Episode 222 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!

Use the SUMIF function to figure out the total sales for each of the sales reps in the database. Episode 221 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!

I can't help but thinking that this request is going to lead to an age discrimination lawsuit in a few months. Today, the managers want an analysis of our employees by certain age bands. The COUNTIF function comes to the rescue, but you have to jump through a few more hoops to make it work. Episode 220 shows you how.

I hate when senior managers ask for headcount by department. It always means that they are looking for a way to trim costs. This podcast won't avert any cost cutting, but it will allow you to produce the report easier. Episode 219 shows 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!

If you need to count records, use the CountIf function to count employees who meet a specific criteria. Episode 218 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!

Is VLOOKUP not finding all your entries? Find out why and how to fix it. Episode 217 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!

Compare and then add new customers and update revenues from daily lists using VLOOKUP. Episode 216 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!

Use VLOOKUP to find the exact match when comparing two lists. Episode 215 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!

Learn how to compare two list to find an exact match. Episode 214 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!

How can you convert a date to the last day of the month? This is hard! 31 days? 30 days? 28 days? 29 days? What is the leap year rule? Never mind - this St Patrick's day podcast solves the problem without worrying about any of those issues. Episode 212 shows 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!