Business and technology shouldn't be difficult

Using SUM function in excel

Published by Atul Kumar Pandey on November 21, 2022.

In excel you can sum range dynamically with the help of SUM function. In this article, we’ll see how to use SUM function in an excel sheet. Make sure you have an office suite installed to use excel.

For example, there are eight teams collecting empty bottles left on the beach. All the teams tried to collect as much as bottles they can. Finally they arrived with their collection numbers.

So here we come with following data:

Team 1101
Team 298
Team 366
Team 4100
Team 540
Team 687
Team 764
Team 893

Now we put those data in an excel sheet with right format and sum it.

The SUM function will be used as:

=SUM(range)
SUM function

The good thing is that if any team reported incorrect number, you can change that value anytime and the excel will automatically calculate everything for you without doing any changes in formula.

You can also use this function directly without range if you have very small numerical data handy.

=SUM(30+20)
The outcome would be 50.

Or directly pick specific cell numbers you wish.

=SUM(cell1, cell2, cell3)

This is how we can use SUM function in excel.

Categorized in Education and tagged in , , , , .

Published by Atul Kumar Pandey

Atul Kumar Pandey is a creator of atulhost. Being a business management graduate, he has a flair for business writing but also likes to dabble in technological trends. He is a voracious reader and an avid tech tester and loves to try new things.

Leave a reply

Required fields are asterisked and email address will not be shared.