Homehow ToHow to do simple math operations (Sum) in Microsoft Excel

How to do simple math operations (Sum) in Microsoft Excel

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.

Excel

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.

Excel

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.

Excel

Select "Sum".

Excel

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.

Excel

Press the "Enter" key on the keyboard or the check mark on the type bar to execute the formula.

Excel

Source of information: howtogeek.com

1 COMMENT

  1. You can also easily add the Sum function via the Keyboard Shortcut: [Alt] + [=]
    In fact, it has automatically selected an area for you to make the additions (of course you can change it effortlessly)

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Teo Ehc
Teo Ehchttps://www.secnews.gr
Be the limited edition.
spot_img

LIVE NEWS