قالب وردپرس درنا توس
Home / Tips and Tricks / How to calculate the sum of cells in Excel

How to calculate the sum of cells in Excel



Excel Logo on a gray background

Microsoft Excel may be known for complex calculations and formulas, but it is no slouch at simple arithmetic. There are a number of ways to find solutions to simple math problems, such as finding the sum of numbers in multiple cells.

Find the sum of numbers in adjacent columns or cells

The fastest way to calculate the sum of squares in Excel is to simply highlight the list of numbers and look at the bottom right of the screen. Here you will find the sum of each selected cell as well as their average and the number of cells you add.

sum at the bottom of Excel

But we assume you want to add the sum to the workbook itself. In that case, mark the numbers you want to add.

highlight cells

In the “Formulas” tab, click “Autosum” to find the sum of the list of numbers. Once you click, Excel will automatically add the sum to the bottom of this list.

autosum formulas

You can also type the formula =SUM(D1:D7) in the formula bar, then press “Enter” on the keyboard or click the check mark in the formula bar to run the formula. Change the letters and numbers in brackets to fit your workbook.

sum formula

Find the sum of numbers in nonadjacent columns or cells

Click an empty cell in the workbook. This should be the cell where you want to display the sum of these nonadjacent columns.

empty cell

In the ‘Formulas’ tab, click the arrow icon to the right of ‘Autosum’.

autosum formulas

Choose ‘Sum’.

autosum and sum

Click on the first digit in the series.

first cell in column

Hold down the “Shift” button and then click on the last digit in that column to select all numbers in between.

shift and click to select

To add the second column of numbers, hold down Ctrl and scroll down from the first to the last number in the column. You can also add the formula =SUM(D1:D7,F1:F7) to the formula bar. Switch the cells in the brackets to meet your needs.

ctrl and click to select

Press the “Enter” button on the keyboard, or the check mark in the formula bar to run the formula.

2 column sum formula




Source link