If you need a Google Sheets formula to add cells together, the fastest solution is to use =SUM or a simple + formula. Both let you add numbers in a row, a column, or across separate cells without doing the math by hand. Once you know which one fits your sheet, building totals, subtotals, and column sums becomes quick and clean.
Use SUM to add cells, rows, and columns
SUM is the main addition function in Google Sheets. It is the best choice when you want to add a range of cells, a whole row, or a whole column. It also works when you want to add several separate cells in one formula. For most spreadsheet work, this is the main Google Sheets addition formula you will use.
Add individual cells
To add specific cells together, place the cell references inside SUM. This is the simplest Google Sheets formula for adding cells when the values are not next to each other.
Example: =SUM(A1, C1, E1)
This adds the values in A1, C1, and E1. You can use as many cells as needed, separated by commas. If you want to add two cells only, this also works well: =SUM(A1, B1).
Add a row of numbers
To add numbers in a row, select the horizontal range. Google Sheets adds every numeric value in that range and ignores blank cells.
Example: =SUM(A1:F1)
This is the cleanest Google Sheets formula for adding rows when the values sit side by side. If you need the total in the next empty cell, place the formula there and point it at the row range.
Add a column of numbers
To add numbers in a column, use the vertical range. This is the standard Google Sheets formula to add up a column.
Example: =SUM(B2:B20)
This is the best answer for Google Sheets how to add numbers in a column. If your column grows over time, you can point SUM at a larger range, such as =SUM(B2:B1000), and it will total everything inside it.
Use the plus sign for direct cell addition
The + operator is the direct Google Sheets addition formula for a small number of cells. It is useful when you want full control over each part of the calculation. If you are searching for a Google Sheets formula to add cells together, this is the most literal version.
Simple addition formula
Type each cell reference with plus signs between them.
Example: =A1+B1+C1
This adds the values in A1, B1, and C1. Use this when you only need to combine a few cells and want the formula to be easy to read at a glance. For longer totals, SUM is easier to maintain.
When to use plus instead of SUM
Use + when the formula has only a few values and those values are fixed. Use SUM when you want to total a range, a row, a column, or many cells at once. If your formula is adding rows of data, SUM is the better choice because it stays readable and easier to edit later.
Add columns and column totals in a sheet
When readers ask for a Google Sheets formula to add column total or a Google Sheets formula for adding columns, they usually want one of two things, either a total at the bottom of one column, or a formula that combines multiple columns across the same row. Google Sheets handles both cleanly.
Total one column
To add up a single column, put the total in the cell below your data and reference the full numeric range.
Example: =SUM(C2:C25)
If your data starts in row 2 and ends in row 25, this formula adds the entire column section. This is the standard Google Sheets formula to add column total and the fastest way to sum a list.
Add several columns across one row
If you want to add values across multiple columns in the same row, use either SUM or plus signs.
Examples:
- =SUM(A2:C2)
- =A2+B2+C2
Both return the same result. If you need a Google Sheets formula for adding columns across a single record, SUM is cleaner because it stays compact even when the range expands.
Add rows, create totals, and fill formulas down
For Google Sheets formula for adding rows, the main idea is to total each row with the same formula pattern. This is common in budgets, inventory sheets, and weekly trackers where each row has separate values that need one total.
Build a row total
Enter the total formula in the last column of the row.
- Click the cell where you want the row total.
- Type =SUM(A2:F2).
- Press Enter.
- Copy the formula down if you need the same total for more rows.
This method works for Google Sheets how to add numbers in a row and keeps your sheet consistent across many records. If each row uses the same layout, drag the fill handle down to apply the same formula to the rows below.
Add totals for multiple rows at once
If each row needs a total in the same column, enter the formula in the first row total cell, then fill it down through the rest of the list. Google Sheets adjusts the row numbers automatically. This is the fastest way to handle Google Sheets formula for adding rows across a table.
How to add data to Google Sheets and bring in other files
Some people search for how to add to Google Sheets when they really mean adding data, adding another sheet, or importing Excel files. These are different actions from using a formula, but they matter when you are building a sheet that needs totals later.
Add data to Google Sheets
To add data, click a cell and type directly into it, or paste a block of copied values into the sheet. You can also use File, Import to bring in a CSV or Excel file. Once the data is in place, use SUM or + to calculate totals from that data.
Add a sheet in Google Sheets
To add a sheet in Google Sheets, click the plus button at the bottom of the workbook. A new tab appears immediately. This is useful when you want separate tabs for raw data, summaries, and calculations.
Add an Excel file to Google Sheets
To add Excel to Google Sheets, open Google Sheets and import the .xlsx file, or upload it to Google Drive and open it there. Google Sheets converts the file so you can keep working with the formulas and data. After import, check any totals that depend on formatting or merged cells, since those can affect calculations.
Common formula patterns for adding in Google Sheets
Once you know the basic pattern, you can solve most Google Sheets formula addition tasks with a few standard formulas. These are the forms readers usually need when searching for Google Sheets formula for adding or Google Sheets formula for addition.
Add a few cells across the same row
=SUM(A1,B1,C1) or =A1+B1+C1 adds three separate cells. Use this when the cells are not adjacent and you want a direct total.
Add a full range of cells
=SUM(A1:A10) adds every value in the range. This is the easiest Google Sheets addition function for a list of numbers, whether they are in a row or a column.
Add multiple ranges together
=SUM(A1:A5,C1:C5) adds two separate ranges in one formula. This is useful when you want one total from different parts of the sheet without building several helper cells.
Add numbers in one column and show a grand total
=SUM(B:B) adds the entire column B. This is a simple Google Sheets formula to add up a column when the column contains only numeric data or when nonnumeric cells should be ignored.
Frequently Asked Questions
What is the best Google Sheets formula to add cells together?
=SUM(A1,B1) is the best all-purpose option, and =A1+B1 also works. Use SUM when you want a formula that stays easy to extend.
What is the Google Sheets addition function?
The addition function is SUM. It adds numbers from cells, ranges, rows, and columns.
How do I add numbers in a column in Google Sheets?
Use =SUM(A2:A20) for a fixed range, or =SUM(A:A) for the whole column. Put the formula below the last number in the column.
How do I add numbers in a row in Google Sheets?
Use =SUM(A1:F1) to total a row. If the values are in separate cells, =A1+B1+C1 also works.
How do I add a new sheet in Google Sheets?
Click the plus button at the bottom of the workbook. A new tab opens, ready for data, totals, or summaries.
Related Posts:
Google Sheets
- How to Change Cell Width in Google Sheets
- How to Calculate Totals in Google Sheets
- How to Calculate Days Between Dates in Google Sheets
- How to Delete or Remove a Filter View in Google Sheets
- How to Merge Cells in Google Sheets
- How to Convert Google Sheets to Excel
- How to Remove a Drop-Down in Google Sheets
- How to Make a Graph in Google Sheets
- How to Remove Duplicates in Google Sheets
- How to Freeze Rows and Columns in Google Sheets
- How to Sort in Google Sheets (A to Z, by Column)
- How to View Hidden Sheets and Rows in Google Sheets