Episode # 222 - Sales by Product and Rep
Sponsored by
Check out this book for more tips
similar to this lesson!
Thursday, March 30, 2006
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.
You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 3 minutes to learn this lesson now with our free video!
Tags/Keywords for this video: Formulas
More Excel Video Lessons
If you like this video, there are hundreds of 2-5 minute videos available here:
- Excel training videos about Charts
- Excel training videos about VBA
- Excel training videos about Pivot Tables
- Excel training videos about Data Analysis
- Excel training videos about Formulas
- Excel training videos about Formatting
- Excel training videos about Printing
- Excel training videos about Excel 2007
- Excel Video Lessons Index
