The screenshots are from the Google Sheets app for iOS, but instructions are the same on all platforms.
Google Sheets includes a built-infunctioncalled SUM for this purpose.
If you change entries or add text to blank cells, the total updates to include the new data.
The range option is how you add columns and rows.
TapEnter text or formulato display the keyboard.
throw in=sum(to start the formula.
Choose the numbers you want to add together.
One way to do this is to tap the cells you want.
The cell references appear inside the parentheses in the formula.
you’re able to include empty cells in a function.
Enter a closing parenthesis to end the function, and then tap the checkmark to fire off the function.
The function runs, and the sum of the numbers you selected appears in the cell you chose.
If you change any of the values in the cells you selected, the sum updates automatically.
Here’s how to do it.
Enter the data, then go for the cell in which you want the sum to appear.
Click or tapFunction(Fx).
In the list of function categories, tapMath.
TheFunctionmenu on the desktop version of Google Sheets contains a few commonly used formulas.
SUM may be on that list.
The functions appear alphabetically.
Scroll down, then tapSUM.
In the spreadsheet, enter the range of numbers you want to add together.
UnderCriteria, chooseList from a rangeorList of items.
This option isn’t available for all data sets.
To pull data from a website into Google Sheets, use theImportFromWeb add-on for Chrome.
you could also use the IMPORTXLM function in Google Sheets, but the add-on greatly streamlines the process.
