Excel is a useful tool for you to add specific cells in Excel. Adding cells is one of the most common things that people do with Excel every day. You can add cells in different methods. We’ll show you how to add specific cells in Excel today with examples. I’m making examples and workbooks with Microsoft 365. You can use the version you prefer.

## 📁 Download Excel File

To prepare this article, we used an Excel workbook, which is available for download. Additionally, you can edit and customize the data you enter while viewing the results.

## Learn to Add Specific Cells in Excel Using These 5 Easy Methods

First of all, let’s talk about the workbook, which is where all of the examples for today come from. Here is a dataset of employee names and their total salaries. We are going to add the salaries in different methods using the **SUM**, **SUMIF**, **CONCAT **functions, etc.

**Method 1**### 1. Utilizing Generic Formula to Add Specific Cells

In this method, we will add values from **column C **individually.

**⬇️⬇️ STEPS ⬇️⬇️**

- Let’s select cell
**C13**. Then simply press equal (=) and then use the mouse to select the**C6**,**C7**,**C8**,**C9**,**C10**,**C11**, and**C12**cells repeatedly.

- Then press
**Enter**. We see the result in cell**C13**.

**📕 Read More: 3 Quick Approaches to Sum Top N Values in Excel**

**Method 2**### 2. Using SUM Function to Add Certain Cells

Now we will use **the SUM function** in this method. The SUM function adds numbers together. You can add single values, references to cells or ranges, or a combination of all three.

**⬇️⬇️ STEPS ⬇️⬇️**

- In cell
**C13**, find the grand total. we type =**SUM**( - Then we’ll have to choose the range of cells by dragging the mouse from
**C6**to**C12**. The formula will look like this

**=SUM(C6:C12)**

- Then we type “
**)**” to close the function and we press**Enter**to get the result.

**📕 Read More: 4 Easy Ways to Add a Range of Cells in Excel**

**Method 3**### 3. Summing Up If Certain Text Is in a Cell

Here we will apply **the SUMIF function**. You use the SUMIF function to add up all the numbers in a range that meet certain criteria. We will add cells on the basis of specific criteria. There are two ‘Tom’ in our list. We will use this as the criteria.

**⬇️⬇️ STEPS ⬇️⬇️**

- Let’s type =SUMIF, then drag the mouse from
**C6**to**C12**to choose the range of names. - Then place a comma and select the criteria by writing
**“*Sam*”**. - Then again type a comma and drag the mouse from
**C6**to**C12**and close by typing “**)**”. The formula will look like this:

**=SUMIF(B6:B12,”*Tom*”,C6:C12**

**)**

- We press
**Enter**to get the result.

**Method 4**### 4. Using SUMIF to Add Cells Based on a Condition

Here we will apply **the SUMIF function**. You use the SUMIF function to add up all the numbers in a range that meet certain criteria. Here we will add salaries on the condition of salaries being higher than 700 dollars.

**⬇️⬇️ STEPS ⬇️⬇️**

- Let’s type
**=SUMIF**, then drag the mouse from**C6**to**C12**to choose the range of names. - Then we give the criteria by “
**>1000**” and close with “**)**”. The formula will look like this:

**=SUMIF(C6:C12,”>700″)**

- We press
**Enter**to get the result.

**Method 5**### 5. Inserting AutoSum Feature to Add Cells

In this part, we’ll use the **AutoSum **command on the **Formula **ribbon to add up the salary.

**⬇️⬇️ STEPS ⬇️⬇️**

- Just press the
**C13**cell, to sum up. - Then, on the
**Formula**tab, press**AutoSum**.

- It will choose the range for you automatically. Then press
**Enter**to get the result.

**📕 Read More: 5 Effective Ways to Sum Random Cells in Excel**

**Method 6**### 6. Adding Cells Containing Text Using CONCAT Function

In this method, we will combine the cells of 2 columns by using **the CONCAT function**. The **CONCAT **function is a text function in Excel that is used to combine text in different cells.

**⬇️⬇️ STEPS ⬇️⬇️**

- Let’s choose cell
**D6**and in order to combine**B6**and**C6**, we type:

**=CONCAT(B6, ” “,C6)**

- Then we drag down the cell to
**Autofill**the rest of the cells.

**Method 7**### 7. Adding Specific Cells Using VBA

We will use **R1C1-style** notation inside a **With Statement **to make a VBA code that adds up a range of cells in rows. In **column E**, we’ll show the total sales of each employee. So, **E6 **is the same as **C6 **plus **D6**, and so on.

**⬇️⬇️ STEPS ⬇️⬇️**

- Let’s press
**ALT + F11**to bring up the**VBA****Window**. You can also do this by going to the**Developer tab**and clicking on**Visual Basic**. - Then we choose
**Module**from**Insert**from the**menu**. This will bring up the window for the**VBA Module**. Here is where we will put our code.

- Now we type the code below:

```
Sub TotalSale()
Dim Z, zTotal As Range
Set Z = Range("B6:D" & Range("B" & Rows.Count).End(xlUp).Row)
Set zTotal = Z.Offset(, 3).Resize(Z.Rows.Count, 1)
With zTotal
.FormulaR1C1 = "=SUM(RC[-2]:RC[-1])"
.Value = .Value
End With
End Sub
```

- Now we save and run the code.

- The result will be seen in
**column E**.

**🔨**** VBA Breakdown**

`👉`

First, we’re going to call our **Sub Procedure** TotalSale.

`👉`

Second, we need to say what type our **variables **are.

`👉`

Third, we set the **range of our cells **so that the **SUM **operation can be done.

`👉`

Lastly, we add up the row totals with the **FormulaR1C1 **property.

`👉`

Here, **RC[-2]** means two columns left, and **RC[-1]** means one column left.

`👉`

We’re telling here that **E6 = C6 + D6**.

**📕 Read More: 7 Easy Ways to Sum Colored Cells in Excel Without VBA**

## 📄 Important Notes

`🖊️`

In Excel, the ribbon is used to access various commands. You can change a lot of things in the options dialogue window, like the ribbon, formulas, proofing, saving, and so on. So the appearance of worksheets on your device could be different from ours.

`🖊️`

A practice workbook is given so that you can practice yourself.

`🖊️`

All these exercises and tutorials are done on Microsoft Office 365. Some functions may be unavailable in previous versions.

`🖊️`

At the end of the Excel file, there is a sheet where they can practice.

## 📝 Takeaways from This Article

`📌`

The reader will be able to add specific cells in Excel easily with various methods.

`📌`

Readers can use **Algebraic sums **to add specific cells.

`📌`

Readers can also use the **SUM **Function to add specific cells in Excel.

`📌`

Moreover, users can sum even if cells contain **specific text **in Excel.

`📌`

They can easily apply **SUMIF **Function to add cells with conditions.

`📌`

Viewers can utilize the **AutoSum **command to add cells.

`📌`

Readers can use **VBA **to add cells.

`📌`

Again, readers can utilize the **CONCAT **function to add cells.

`📌`

One will be able to find the quickest way to add specific cells in Excel.

## Conclusion

That concludes today’s session. These are the methods for adding specific cells in Excel. We are hopeful that this article will be extremely beneficial to you. Don’t forget to leave your thoughts and questions in the comments section and explore our website, **ExcelDen**, the best Excel solutions provider.