Everyone uses the SUM function, but have you ever used a 3D SUM function? This technique is flexible and allows you to easily include or exclude sheets from totals.

Do you know how and why to use SUMIF and SUMIFS functions? If you need to do a multi-criteria SUM in Excel 2003 have you tried the SUMPRODUCT function? Discover some of the powerful uses of SUMPRODUCT.

Find out why you shouldn’t use the SUM function for subtotalling and how you should do subtotals. Also learn about a new function addd in Excel 2010 that can ignore error cells when summing.