Formula to add cells in excel (2 Easiest Methods)

August 1, 2022

A free Office suite fully compatible with Microsoft Office

Free Download

The formula to add cells in Excel allows you to add an entire column, a range of cells, and non-adjacent cells. It is one of the most used Excel functions because it lets you know the sum of the critical data.

If you want to know the formula to add cells in Excel, you are right. Below you will find different options that you can use to sum cells in Excel.

How to use the formula to add cells in Excel using AutoSum on Windows?

You can let Excel do all the calculations if you need to add a row or column of numbers. To learn the formula to add cells in excel 2019, you must perform these steps:

1. Click AutoSum on the Home tab and then press Enter.

2. When you click AutoSum, Excel automatically enters a formula (Using the SUM function) to add the selected numbers.

An example, you can add the numbers for January and select cell B7, the cell immediately below the column of numbers. Then click AutoSum. A formula will appear in cell B7, and Excel will highlight the cells it's totaling.

3. Press Enter to display the result in cell B7. Also, you can see the formula in the formula bar at the top of the Excel window.

Note: If you want to add a row of numbers, you must select the cell immediately to the right. To add a column of numbers, you will need to select the cell immediately below the last number in the column. Go to “AutoSum” found in 2 locations: “Home” > “AutoSum” > “Formulas” > “AutoSum”.

As you can see, the formula to add cells in excel 2016 is simple; anyone can do this equation.

How to use the formula to add cells in Excel Simple Sum?

If you want to know the formula to add cells in excel online, you must follow these steps:

1. The formula to add cells in Excel that contain numbers will allow you to add all the numbers using the simple addition option.

2. You can add the values of the cells, for example, from cell B2 to B6, by typing the following formulas in another cell of the spreadsheet. If you look at the example, the formula begins to be typed in cell B6, and you can see how the cells of the formula you have typed are highlighted.

3. When you press Enter, the formula will be stored in the cell, and the result of the formula will be displayed as it appears in the image.

4. Please note that if one or more of the cells are empty or contain text instead of numbers, Excel will ignore those values when calculating the result.

Also, remember that it doesn't matter if you write the formula in lowercase or uppercase. Each time you type, Excel will automatically convert each letter to uppercase when you press Enter.

The good thing about using the formula to add cells in excel mac is that it will always show the current value of the sum of said cells. Every time you change one of the values in the selected cells, the value in the sum cell will immediately change to show the correct sum.

Did you learn how to use the formula to add cells in Excel? You will have the opportunity to perform sums in Excel and improve your work experience.

It will also allow you to download WPS Office to create, edit and process your Excel, PowerPoint, and Word documents.