You can perform many different mathematical operations in Google Sheets, including the addition of numbers. You can add numbers across columns or rows, or even numbers in different cells. Here’s how it’s done.
You can quickly add numbers in a single cell by using the
=#+# formula. For example, if you wanted to get the sum of 2+2, you’d enter:
Press Enter to return the result.
That’s all there is to it!
You can quickly get the sum of numbers in a single row or column by using the SUM function. Let’s say we want to get the sum of the numbers in cells A2 through A6. First, select the cell that you’d like to calculate the sum in, and enter this formula:
This function tells Google Sheets that you want to get the sum of the numbers from A2 through A6. Be sure to use a colon (
:) between the cell numbers. If you use a dash (
-) which is often used to describe “everything in between,” then Google Sheets will subtract the input cells instead.
Once you’ve entered the correct formula, press Enter and the result will appear.
Similarly, you can add the numbers in a row by taking a similar approach. Let’s say that, instead of adding the numbers from Column A, we want to add the numbers in Row 2 (A2 through E2). Select the cell you want to calculate the sum in and then enter this formula:
Press Enter the display the results.
You don’t have to reenter the formula multiple times. If you want to quickly get the sum of multiple rows or columns, you can enter the formula once and then use the drag-and-drop method to quickly get the results.
First, enter the SUM function in the cell to get the sum of the first row (or column). So, if you want to get the sum of cells A2 through C2, you’d enter:
Press Enter to get the result. Then, simply click the bottom-right corner of the cell and drag it down. Google Sheets will automatically update the SUM formula for each row (or column).
You can get the sum of numbers from cells in different columns and rows by simply replacing the colon (
:) with a comma (
,) in the SUM formula.
For example, if you want to get the sum of cells A2, B3, C5, and D4, you’d enter:
Press Enter to get the result.
If you just need a quick answer and don’t really have time to enter a formula, Google understands. All you need to do is highlight the cells you want to get the sum for by clicking and dragging your cursor over them.
Once selected, Google Sheets automatically adds them for you. Just take a look at the bottom-right corner of the window!
- › How to Make and Share a Household Budget in Google Sheets
- › How to Use the ARRAYFORMULA Function in Google Sheets
- › How to Make Branded Email Templates With Layouts in Gmail
- › How to Back Up Your BitLocker Recovery Key on Windows 11
- › How to Freeze Multiple Rows in Microsoft Excel
- › PC Power Consumption Is Getting Out of Control
- › Amazon’s Fire TV Sticks Are at Their Lowest Prices Yet
- › You Can Now Customize Windows 11’s Look With WindowBlinds