Learn Excel Episode 222: Sales by Product and Rep
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.