How to Add Specific Cells in Excel (5 Easy Ways)

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.

Adding Specific Cells in Excel


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.

Adding Specific Cells in Excel with algebraic sum

📕 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)

Adding Specific Cells in Excel using SUM

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

Summing up Specific Cells in Excel

📕 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)

Sum in Excel if certain text is in a cell

  • 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″)

Use SUMIF to add cells based on a condition

  • 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.

Insert the AutoSum command to add cells

  • 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)

Add Cells Containing Text Using CONCAT function

  • 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.

Add Cells by VBA

⬇️⬇️ 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.

how to add specific cells in excel using VBA

🔨  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.


Related Articles

(Visited 95 times, 1 visits today)
Tanzim

Tanzim

My name's Tanzim. My articles are meant to help you learn more about how Microsoft Excel works and how to use its different features. I enjoy gaming and hope that some of my knowledge will help me provide you with some interesting articles despite some tiresome technical terms.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo