Learn Excel Episode 222: Sales by Product and Rep

Posted in Companies, Podcasts on June 30, 2008


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.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel