How to Add a Range of Cells in Excel (7 Methods)

Microsoft Excel is a powerful productivity software. It can be used to organize huge datasets and is used in many businesses and corporations for various data-related purposes. Excel not only helps you to organize your data it also provides you with various tools to analyze your data and make decisions. Being a very smart software, sometimes there are various ways to do the same operation in excel. The summation of data is one of the most common operations of data analysis. It helps you to get your total amount. Today we will learn some easy ways to sum a range of cells using different methods.

Practice Workbook

Here, we will practice using a dataset of employee working hours of Inspire Stationary.

Easy ways to Add a Range in Excel

About the Pactice Workbook

Total Dataset

Here we can see the datasheet contains Inspire Stationary’s employees working hours and weeks. We will learn how to add their total week, total week/hour, and total working hours using various methods.

How to Add a Range of Cells in Excel

There are many ways to add a range of cells in Excel. We will use AutoSUM and SUM Functions in this article. We will also learn how using these two methods can help us add different types of ranges (Column range, row range, and Column + Cell range)

I. Using AutoSUM

Excel helps you to increase your productivity by providing the most useful operators within your reach. Some basic functions are right there whenever you need them. As its name suggests, AutoSUM will help you sum all the values of a column automatically. Very easy! Right? Let’s see

1. Column Operations

Select your Data Range (C5:C11). Select Numerical Values only. You can use a keyboard or mouse. If your dataset is large I would suggest using the keyboard.

Column Range Selection

From Home tab go to Editing section and select AutoSUM.

Autosum Column

There’s your total week of all the employees.

2. Row Operations

You can do the same operation for Rows too. Like in this datasheet if you want to calculate Ted’s sum of weeks+Hours/week+Total Hours

Select Data Range (C10:E10). This time Ted’s row but only the cells that contain Numerical Data

Row Range Selection

From the Home tab go to the Editing section and select AutoSUM.

Autosum Row

That’s your Row Sum

3. Range Operation with Rows and Columns

So if we want to get total sum of all categories for all employees (so sum both columns and rows) AutoSUM can do this too.

Select Data Range (C5:F12). 

From Home tab go to Editing section and select AutoSUM.

Autosum Row + Column - Autosum

That’s how you can use AutoSUM to calculate Range on Rows and Columns.

II. Using SUM Function

Sum function is and will be one of the most used functions in Excels. The SUM function provides you with more flexibility than AutoSUM as you can select deliberate cells and add them. Of course, you can select specific ranges to get the sum of them. The range can be either Rows, Columns or mix of Rows and Columns. Let’s see how SUM functions can help you sum your data.

1. To Calculate Random Data

In the case of our example suppose you want to calculate sum of Ted, Alen and Mike’s week in C14 Cell.

Select C14 Cell

Cell selection

Now in the Formula Bar or Inside the cell write

=SUM(C5+C10+C11)

Cell Formula for Random Cells

Done.

2. To Calculate Range Data

i. Using Individual Selection

Following the previous procedure you can calculate range values too. Like In the exam if you want to sum the total weeks in Total row in C12 Cell

=SUM(C5+C6+C7+C8+C9+C10+C11)

Long Sum formula for Large Columns

This way you can also sum a Range too.

=SUM(C5+D5+E5)

Long Sum formula for Large Columns

If you have a large dataset then this might become tedious. Worried? Don’t.

ii. Using Bulk Selection Method

In this method, we will be using keyboard or mouse to select a range of data which can be in the same column or row or consecutive rows and columns. We can also use Mighty Colon(:) to indicate relevant data.

Like previous methods we have to select a cell ( in our example we used C16 Cell) where the sum result will be displayed and the use the Formula bar or double click inside the cell to write

=SUM(

then use mouse or keyboard to select data.

Or, you can use Colon(:) sign to define Range as it can also be seen in the Formula bar.

=SUM(C5:D11)

Row Column Selection for Sum Function

Concluding Words

I hope you find all of these simple methods mentioned above helpful for you to apply them in your Excel spreadsheets when needed. If you have any questions, please let me know in the comment section. Feedbacks are welcome too.

Shahin Mahmud

Hello I am Shahin Mahmud. I love working with Excel. I am a Civil Engineer holding a Bachelor’s degree from Bangladesh University of Engineering and Technology. I am interested in anything related to computers and phones. I also like to help people facing computer related problems and write articles about them.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo