Episode # 662 - SumProduct
Do conditional sums with SUMPRODUCT
Sponsored by
Check out this book for more tips
similar to this lesson!
Friday, December 28, 2007
There. I said it. SumProduct. Some of my friends in the U.K. seminars asked why I NEVER talk about SumProduct. And there is a really simple, but really stupid reason for it. I missed that day in Excel class. SumProduct simply was not in my arsenal of tools, and so I find myself writing complex array formulas when a SumProduct would do the trick. In today's Episode 662, we take a look at how to convert yesterday's array formulas to SUMPRODUCT formulas. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
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, SumProduct, conditional sums
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
