From the course: Excel Formulas and Functions Quick Tips
Calculate a total with SUM - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Calculate a total with SUM
- [Instructor] The SUM function adds numbers that you specify, or a range of cells and returns the result. I'll type =SUM, put in my open parentheses, and I can either type in my range manually, or click and drag to select the range. I'll close the parentheses, hit Enter, and get my sum. It's important to note that you can always select a range of cells, and down at the bottom of the screen on the right hand side, Excel will return the sum for you. You can also select a range of cells and click AutoSum from the Home ribbon tab.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Calculate a total with SUM42s
-
(Locked)
Sum values that meet specific criteria with SUMIF1m 8s
-
(Locked)
Find the mean value with AVERAGE1m
-
(Locked)
Test for valid data with IF2m
-
(Locked)
Create complex tests with AND and OR2m 2s
-
(Locked)
Find record values with MAX, MIN, SMALL, and LARGE1m 12s
-
(Locked)
Perform date calculations with TODAY()1m 3s
-
-
-
-
-
-