In the previous video, you used the quick reference tool to count the numbers in yoursheet. This is useful when you want to make calculationsfor a specific range of cells quickly. But sometimes you need calculations to becompleted automatically, even when the contents of the cells change, without having to selectand retotal the numbers. To do this, use a SUM function. Functionsmake calculations easier, faster, and more accurate.
The “SUM function” adds a range of values in spreadsheet cells.
To begin, type the function next to the range of cells you want to add; in this case, thesize large shirts. Functions in Google Sheets always start withan “equals sign.” Next, type the word SUM. A menu provides formattinghelp. Select “SUM.” Then, select the cells you want to add.
Finish with a close parenthesis. And press enter to complete the function.
Nice job! Check your work by selecting the cells in the row and noting the quick referencesum. Now, replace one of the numbers in the rowwith a new number. Press enter to update the function.
Your sum updated automatically! Undo your change so your data isn’t affected.
To copy the function to the other rows, click the handle in the corner of the cell and dragit up or down to populate the other rows. Then use the same function to sum up the totalsfor each shirt order... And the totals for all shirt sizes.
Next, label the new column.. Give your table a title...
and match the formatting of your other table, if you like.
Now, it’s your turn: Use the SUM function to add the number ofshirts sold by size, Use the SUM function to add the total numberof shirts sold, Give the table a title,And add fill colors, bold formatting, and center alignment to the data.
1. Introduction to G Suite Certification: Sheets - Part 2
2. Sheets: Create Filters and Use Filter Views
3. Sheets: Use Filters to Count, Add, and Summarize Data in a Table — Use Sheets and COUNT
4. Sheets: Use the SUM Function to Analyze Data
5. Sheets: Display Data in a Chart — Create, Insert, and Modify Charts, and Protect Sheets and Ranges
6. Sheets: Use COUNTIF to Generate Numeric Data with Text Values
7. Sheets: Share and Collaborate — Add Comments, View Revision History, and Download Spreadsheets as File Types