Susan asks..."I have been using SUMPRODUCT a lot ever since you showed me how since I cant use SUMIFS for users with pre-2007 version. But, is there an AVERAGEPRODUCT or something similar? How about MAXPRODUCT?"
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Episode 1198 takes a look at the Nudge Selection tool in Easy-XL. ...This blog is the video podcast companion to the book,Learn Excel 97-2007 from MrExcel.
Jim from California asks why it takes two clicks to create a new workbook in Excel 2007. Episode 1197 shows you the solution. Learn Excel 97-2007 from MrExcel.com
Patrick from Alaska asks how to copy a chart but detach it from the original data set. In this Dueling Excel podcast, Mike and Bill show you various solutions. Learn Excel 97-2007 from MrExcel
As envisioned by Professor Tufte, sparklines could have a bit of shading to show the acceptable ranges. While this is not necessarily built into Excel 2010, you can achieve the same effect. Episode #1195 show you how
In Episode 1194, we take a look at how to add labels to your sparklines.
...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!
Robert asks about using a pivot table to report on text values. This would be easy if Microsoft offered a way to specify "First" as the calculation, but they don't. Instead, Episode #1193 shows a Pivot/VLOOKUP solution to the problem.
Mary asks about how to force a report to fit to one page wide. Episode #1192 takes a look at Layout mode, Scale to Fit, and orientation. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
This isn't so much of a dueling podcast as Bill being obnoxious and breaking Mike's worksheet. Maybe there is a use for this, or maybe not. Episode #1191 will show you how.
