Google Sheets Algorithm

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, Algorithms handle these changes 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 calculate with constantly changing variables.

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

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

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

Step 2.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”.