4. Sheets: Use the SUM Function to Analyze Data

In the previous video, you used the quick reference tool to count the numbers in your sheet. This is useful when you want to make calculations for a specific range of cells quickly. But sometimes you need calculations to be completed automatically, even when the contents of the cells change, without having to select and retotal the numbers. To do this, use a SUM function. Functions make 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, the size large shirts. Functions in Google Sheets always start with an “equals sign.” Next, type the word SUM. A menu provides formatting help. 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 reference sum. Now, replace one of the numbers in the row with 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 drag it up or down to populate the other rows. Then use the same function to sum up the totals for 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 of shirts sold by size, Use the SUM function to add the total number of shirts sold, Give the table a title, And add fill colors, bold formatting, and center alignment to the data.