By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-sum/

Learn how to use Excel's SUM function to quickly add up ranges of numbers. You'll learn how to write a SUM function from scratch and how to insert one using the AutoSum feature. You'll learn how to sum values on a single worksheet and across a range of worksheets. You'll also learn how to quickly calculate running totals with careful use of absolute and relative cell references.

Chapters
00:00 Topic list
00:36 Basic SUM Functions
03:17 Using the AutoSum Feature
05:16 Summing Multiple Ranges
07:36 Using SUM in Group Mode
09:44 Summing Across Worksheets
12:45 Creating Running Totals

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!