SUMIF function adds the values of the selected range that validates the given condition/criteria in the formula. It will display the addition result just below the last cell of your selected range. You can select the cell range for addition and click AutoSum. You can do the same for adding the numbers in a row also. You have to press enter to display the result. Select a cell just below the column numbers which you want to add and click AutoSum, under the Editing group of Home tab.ĪutoSum directly displays the formula for the sum and also highlight the cell range automatically taken by the AutoSum. Below I have given an example of adding the cells using the add operator.Īfter typing the formula press enter to obtain the result. In the cell type the formula for adding the desired cells or numbers.Īs you will go on typing the formula, the cells you have mentioned in formula will get highlighted. Here, you have to select a cell where you want the result of the addition to be stored. We can simply add the values in several cells using the sum operator ( +). So let us start with the steps to add or sum in MS Excel 2016. We will discuss how we can simply add numbers in the cells using the operator? How we can add using AutoSum, using SUMIF formula? We will also discuss how we can add only selected cells using Filter? In this section, we will discuss the other options which can also be used to add the cells in excel 2016. It generates the sum of two or more cells in a sheet quickly.

One of the popular method to add in excel is AutoSum. You have a variety of method to add or sum in Excel.

Adding is a basic mathematical operation, and is often used during the mathematical calculations.

How enable adding columns in excel 2016