Friday, November 20, 10:33
Home how To How 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 ANSWER

Please enter your comment!
Please enter your name here

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

LIVE NEWS

Cyble: accused of blackmailing victims of data breach

The emerging cyber security company, Cyble, which offers Dark Web monitoring services in real time, seems to be facing ...

GO SMS Pro: The popular chat application exposes user messages

GO SMS Pro, a popular Android chat application, with 100 million downloads, exposes private messages (mainly multimedia files) that send between ...

Google Messages Will Automatically Delete Your OTPs After 24 Hours

An teardown APK from XDA Developers has revealed that Google Messages will automatically delete your OTPs after 24 hours. Google Messages is the default ...

Microsoft hacked

The internet giant, Microsoft, fell victim to a hacking attack

Nitro PDF: thousands of users may have been affected by a breach

Thousands of New Zealanders may have been affected by a serious data breach in Nitro PDF before ...
00:02:48

Scientists have solved the mystery of the blue ring in space!

Scientists have finally solved the mystery about the bright blue ring of light that is different from anything astronomers have seen in ...

Windows 10: How to terminate a task using Task Manager

If you want to close an application that is stuck in Windows 10, you can easily terminate a task using the built-in utility ...

How to run iPhone and iPad applications on Mac

If you have a Mac supported by Apple Silicon, you no longer need to remove your iPhone or iPad for ...

Research: Australian companies adopting multi-cloud are more likely to pay a ransom

According to a survey conducted in Australian companies, those who use multi cloud are at greater risk of being exposed to a ransomware attack ...

Skimmer Grelos shows the difficulty of detecting Magecart attacks

The discovery of a new variant of skimmer - the Grelos - reveals the difficulties associated with locating various Magecart campaigns.