Reaching way back to the archives, the DSUM function allows for some pretty amazing criteria. Episode #1232 discusses how to build smaller criteria ranges for DSUM.
This episode is the podcast companion to "Excel 2010 In Depth", by Bill Jelen.
-
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.
Excel 2010 adds a new function called 'AGGREGATE'.
This function is similar to SUBTOTAL, but with several new tricks, including MEDIAN, LARGE, SMALL, and the ability to ignore error values. Episode #1231 explores this new Excel Function.
From Chapter 9 of "Excel 2010 In Depth", learn how to join text from column A with text from column B using the concatenation character.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Episode #1229 shows you how to manually define a relationship between two tables in PowerPivot.
...This episode is the video podcast companion to the book, "PowerPivot For The Data Analyst: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.
There is more than one way to enter a formula in Excel. Episode #1228 shows three (3) ways to successfully enter a formula in Excel.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Jump to the edge of a large data set by using the 'End' key to navigate in Excel. Episode #1227 shows you how!
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
If you need to access the Excel 2003 dialog box for many commands, you can easily do this in Excel 2010. Episode #1225 of the MrExcel Podcast shows you how to use the dialog launchers.
In this episode [Episode #1224], learn how to have a loop hit every other row instead of every row using the Step command.
...This episode is the video podcast companion to the book, "VBA And Macros: Microsoft Excel 2010", from Bill Jelen
In this episode of the MrExcel Podcast series [Episode #1223], you will learn how to customize the Excel 2010 ribbon to suit your needs. ...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
