Google Sheets Function

One of the greatest parts of Google Sheets is its ability to perform calculations with large, constantly changing data. Manually changing values that depend on other data would be tedious. Functions handle these changes for you. For instance, if you wanted to add a column of numbers together, you could create a function that would do this equation for you.

1. A laptop or device with internet access
2. A Google Account
3. A Google sheets document with a data set

This data set does not need to be complete and will be calculated with constantly changing variables.

Step 1. Select the box next to the “Total amount” box

Step 2. Write “=” and then whatever you want the algorithm to do (SUM for addition, MULTIPLY for multiplication) followed by “()”

Step 3. Within those parentheses, write the letter/number location of the variables you want added, multiplied, etc. For example, I’d write “C2:C11” for C2 through C11 to be added together.

Step 4. Repeat those steps for the box next to “Total Cost” (using the right variables)

This algorithm adds all the quantities together and displays the answer in the box next to “Total Amount,” and adds the cost of everything and displays it next to “Total Cost”.