Learn how to calculate sales by product and rep in this video.
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!