Microsoft Excel is known for the complex calculations it can perform. Of course it is very good even in simple mathematical operations. There are several ways to find solutions to simple math problems, such as finding the sum of numbers in many cells.
Find the sum of the numbers in adjacent columns or cells
The fastest way to calculate the sum of numbers in Excel is to simply highlight the list of numbers and check its bottom right screen. Here, you will find the sum of any selected cell, as well as him average and the number of cells you add.
However, we will assume that you want to add the amount to the workbook itself. In this case, highlight the numbers you want to add.
From the "Formulas" tab, click on "Autosum" to find the sum of the list of numbers. Once clicked, Excel will automatically add the sum to the bottom of this list.
Alternatively, you can enter the formula = SUM (D1: D7) in the type bar and then press “Enter” on the keyboard or click the check mark in the type bar to run the press. Change the letters and numbers in parentheses to fit your workbook.
Find the sum of the numbers in non-adjacent columns or cells
Click any empty cell in workbook. This should be the cell where you want to display the sum of these non-adjacent columns.
From the Formulas tab, click the arrow icon to the right of Autosum.
Click on the first number in the series.
Hold down the "Shift" button, then click the last number in this column to select all the numbers.
To add the second column of numbers, hold down Ctrl and scroll down from the first to the last number in the column. Alternatively, you can add the formula = SUM (D1: D7, F1: F7) to the formula bar.
Press the "Enter" key on the keyboard or the check mark on the type bar to execute the formula.
Source of information: howtogeek.com