Add Columns or Rows in Google Sheets – Knowligent
Add Columns or Rows in Google Sheets

Add Columns or Rows in Google Sheets

HomeHow to, TechAdd Columns or Rows in Google Sheets

This article explains how to use the SUM function in Google Sheets using the Functions menu, entering it manually, and using the Function icon. The screenshots are from the Google Sheets app for iOS, but the instructions are the same on all platforms.

Google Sheets – How to Sum a Column/Row in Google Sheets

Adding rows or columns of numbers is a common operation performed in all spreadsheet programs. Google Sheets has a built-in function for this called SUM. The function automatically updates the spreadsheet when you make changes to the range of cells in the formula. If you change entries or add text to empty cells, the total is updated to include the new data.

Using the above information, write a SUM function like this:

In this case, the numbers in parentheses are the individual cells being added. This can be a list, like (A1, B2, C10), or a range, like (A1:B10). The range option is how you add columns and rows.