Type in “SUMIF” or select the SUMIF function from the drop-down menu.

Select the cell you want to show the summation to (In my case, cell F12).

If the sum_range is not specified, the range’s cells are added together instead.īy using this method, you can get the summation of specific cells based on certain criteria. Range: The range of cells on which the criteria should be applied.Ĭriteria: The criteria that determine which cells to add. The syntax of the SUMIF function is as follows: It will automatically insert a formula with the SUM function and appropriate arguments based on the adjacent cells (In my case, the Sales column) and show you the summation in the selected cell.

Go to Home and click the “AutoSum” option under the Editing section or press Alt + = (Equal sign) and hit Enter button.

Select the cell you want to show the summation to (In my case, cell C17).

You just have to click the option, and Excel will insert the formula for you. This is the easiest method as Excel automatically handles everything. You can also use the “AutoSum” option to perform the sum operation automatically. Read More: How to Sum Multiple Rows and Columns in Excel 3. You can choose a range of cells or multiple columns and rows as well. It will sum the values of the cells you entered and get you the output in the selected cell.

Select the cells you want to get the summation of (In my case, C1, C5, C7) and hit Enter button.

Type in “SUM” or select the SUM function from the drop-down menu.

Select the cell you want to show the summation to (In my case, cell F4).

The 1st argument is mandatory, others are optional, and it takes up to 255 numbers.įollow these steps to get the summation using the Excel SUM function: It takes these inputs and shows their summation as output. The SUM function takes 3 types of inputs: positive or negative numeric values, range, and cell references.

The syntax of the Excel SUM function is as follows:

Now, type in the desired cell numbers with a plus (+) operator in between (In my case, C3+C5+C7) and hit the Enter button.

Select the cell you want to show the summation to (In my case, cell C19).

You can perform a sum operation between cells by adding cells with a plus (+) operator.įollow these steps to apply this solution: I have used different cells from this dataset to explain the 4 subsequent methods. It has 3 columns ( Date, Sales Rep, and Sales). The following image is of the dataset which is used throughout this article.

Use quick analysis tool in excel to sum