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.
Find out why you shouldn’t use the SUM function for subtotalling and how you should do subtotals. Also learn about the AGGREGATE and SUBTOTAL functions. Discover their super power!
See how to do complex conditional sums using the SUM function.
Discover the things SUMIFS can't do and how SUM can do them.
Learn the tips, tricks, traps and techniques to get summing right in Excel.
Discover how to do 3-D sums plus how to use the SUMIFS, SUBTOTAL and AGGREGATE functions.
See how SUMPRODUCT works plus how to do complex conditional sums with the SUM function.
Version: All versions
Recorded: August 2025
Level: Intermediate
Duration: 1 hour
Price: AU$25