How to Add Multiple Cells in Excel (7 Easy Ways)

We have a list of employees of a company, their corresponding working days, and their salaries. We will use this dataset to add cells.

how to add multiple cells in excel

Method 1 – Using the AutoSum Feature to Add Multiple Cells in Excel

We’ll use a table of people’s names and their working days to add the working days.

Use of AutoSum Feature to Add Multiple Cells in Excel

Steps:

Click on cell C10 go to the Home tab.
From the Editing group of commands, click on AutoSum.

autosum

In Cell C10, a formula appears and points to the cells we want to add.

Hit Enter.

Use of AutoSum Feature to Add Multiple Cells in Excel

You can also do this by going to the Formulas tab and selecting AutoSum.

The result will be the same.

Use of AutoSum Feature to Add Multiple Cells in Excel

Read More: How to Add Specific Cells in Excel

Method 2 – Applying an Algebraic Formula to Add Multiple Cells in Excel

We’ll change the sheet to contain all employee salaries. We are going to add all the salary cells to get the total salary in Cell C10.

Applying Algebraic Formula to Add Multiple Cells in Excel

Steps:

Select Cell C10 and type the Equal (=) sign.
Click on the first cell to add and type the Plus (+) sign.
Click on the second cell and add a plus sign.
Repeat until you add all cells.

Press Enter.

Applying Algebraic Formula to Add Multiple Cells in Excel

Read More: How to Sum Selected Cells in Excel

Method 3 – Inserting the SUM Function to Add Multiple Cells in Excel

We’ll get the total salaries of the employees.

Utilizing SUM Function to Add Multiple Cells in Excel

Steps:

Insert “=SUM(“ in Cell C10.
Select the range of cells that you want to add up.

Press Enter.

Utilizing SUM Function to Add Multiple Cells in Excel

Read More: Shortcut for Sum in Excel

Method 4 – Adding up Multiple Cells with a Condition Using SUMIF Function

We have a worksheet with some salespeople, their sales quantity, and the sales amount. We are going to add up the sales amount where the quantity is less than 5 and the sales amount that is lower than $6,000.00.

Utilizing SUMIF Function to Add Multiple Cells with conditions in Excel

Steps:

Use the following formula in cell C10.

=SUMIF(C5:C9,"<5",D5:D9)

Mark, Hank, and Rock have quantities smaller than 5 and so their corresponding sales amount will be added up here.

Press Enter.

Utilizing SUMIF Function to Add Multiple Cells with conditions in Excel

Insert the following formula in cell D10.

=SUMIF(D5:D9,"<6000")

The SUMIF function goes through column D to find the values which are smaller than 6000 and then adds them up.

Hit Enter.

Utilizing SUMIF Function to Add Multiple Cells with conditions in Excel

Method 5 – Adding Multiple Cells Containing Texts in Excel

We will add up the cells of the First Name column with the cells of the Last Name column to form the full names in the Full Name column.

Add Multiple Cells with texts in Excel

Case 5.1 – Applying the CONCATENATE Function

Steps:

Use the following formula in cell D5.

=CONCATENATE(B5," ",C5)

Press Enter.
Drag down the Fill Handle tool.

You will get all of the full names of the employees.

Using CONCATENATE function to Add Multiple Cells with texts in Excel

Case 5.2 – Applying the TEXTJOIN Function

We’ll use the same dataset.

Using TEXTJOIN function to Add Multiple Cells with texts in Excel

Steps:

Use the following formula in cell D5 and press Enter.

=TEXTJOIN(" ",TRUE,B5,C5)

Here, ” ” is the separator of each text, TRUE is for ignoring blank cells, and B5 and C5 are the texts.

Drag down the Fill Handle tool.

You will get the combined texts in the Full Name column.

Using TEXTJOIN function to Add Multiple Cells with texts in Excel

Case 5.3 – Using the Ampersand Operator

We will get the full names by combining the two parts of the names using the Ampersand operator.

Using Ampersand operator to Add Multiple Cells with texts in Excel

Steps:

Use the following formula in cell D5 and press Enter.

=B5&" "&C5

Drag down the Fill Handle tool.

You will get the full names.

Using Ampersand operator to Add Multiple Cells with texts in Excel

Method 6 – Adding a Constant Number to Multiple Cells Simultaneously

We are going to add the value in cell E5 to multiple cells of the Salary column.

Add same number to Multiple Cells in Excel

Steps:

Select Cell E5 and copy it by pressing Ctrl + C.

Select the cells where you want to add the copied values and right-click.
Click on the arrow symbol next to Paste Special and click on Paste Special again to see more options.

The Paste Special dialog box will appear.
Select Values and, in the Operation section, select Add.
Click OK.

Add same number to Multiple Cells in Excel

You can also open up this dialog box by pressing Ctrl + Alt + V.

We can see that 100 has been added to all of the salaries.

Apply the Currency format again to get the following outlook.

Add same number to Multiple Cells in Excel

Read More: How to Add Numbers in Excel

Method 7 – Adding Values of Multiple Cells for a Dynamic Range

We will add up the values of the Salary column in such a way that if we add an extra cell in this column then the value will be automatically added up in the final result.

Add numbers for a dynamic range in Excel

Steps:

Use the following formula in Cell E5.

=SUM(OFFSET($C$5,0,0,COUNTA(C:C)-1))

$C$5 is the starting cell of the range, while the following 2 zeros are indicating that the cell reference will not move by any row or column number. COUNTA(C: C)-1 indicates the height number of the range which will be the number of rows having texts or numbers.
The OFFSET function will return the dynamic range and the SUM function will add up them.