Exploring All Ways to Use the SUM Function in Excel

Whether you’re summing ranges, named data, non-contiguous cells, or values from different sheets, this video covers it all. Learn how to simplify your calculations, use named ranges for more readable formulas, sum entire columns, and even pull data from other sheets effortlessly. 00:00 Basic SUM Operation 00:44 Sum Non-Contiguous Ranges 01:14 Sum Named Ranges 01:49 Sum Entire Columns 02:14 Sum Data from Another Sheet 02:34 Sum a Mix of Different Data Types