If you need to find the total of a column when you're using Google Sheets, look no further than the SUM function. You can create a simple formula with SUM that quickly adds all cells in any column. SUM also works to add values in rows, as well as in ranges that combine both rows and columns. We'll show you how easy it is use SUM to add numbers anywhere in your spreadsheet on your PC or Mac computer.
Go to https://sheets.google.com in a web browser. If you're not already signed in to your Google account, follow the on-screen instructions to sign in now.
Click the file you want to edit.
Click the cell where you want to place the result. This can be any blank cell on the sheet.
Click Σ. It's near the top-right corner of the sheet. This opens the function menu.
Click SUM. It's at the top of the menu.
Select the cells you want to add. To do this, click the first cell in the column, then drag the cursor down until all cells are selected.
Press ↵ Enter or ⏎ Return. The total of all values in the column now appears in the cell.
Comments
0 comment