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!

OK....the trick that I used in podcast 210 happened to work for automatic subtotals, but it won't work for a lot of other formulas. Episode 211 will show you the real way to solve this problem, reliably, day after day. 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!

Make a series of daily dates appear as a month. Episode 210 will show you how. As a bonus, check out the subtotal feature at the end of the 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!

10 runners each ran for about 3 minutes and Excel gets a total of 7 hours! I hate when Excel gives what appears to be the wrong answer. In Episode 209, see why Excel whacked out with this simple time problem and how to fix it. 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!

In today's episode, someone keyed in hundreds of cells with time and they keyed them all as text. Luckily, though they keyed it in a format that looks exactly like a time Excel would understand. The formula for today's solution is far easier than podcast 207. Episode 208 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!

Someone entered a million time values as text. How can you convert them to real times? Episode 207 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!