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

To add specific cells here I will show how to do it in some easy ways in Excel. Go through the flows of the screenshots carefully and hope you will be able to understand them with simple explanations. 


Download Practice Book

You can download the Excel workbook that has been used to prepare this article.


5 Quick Methods to Sum Specific Cells in Excel

Method 1: Use Algebraic Sum to Add Specific Cells

Here in this dataset, we will add the values in cells C4, C5, and C6 to show the output in C10.

To do it just press equal(=) and then select the C4, C5, and C6 cells serially by using the mouse.

Use Algebraic Sum to Add Specific Cells.

» Now just hit the Enter button and you will get the result in the C10 cell.

Use Algebraic Sum to Add Specific Cells.


Method 2: Insert SUM Function to Add Specific Cells in Excel

We’ll now insert the SUM function.

» To find the grand total in the C10 cell we will type =SUM(

» Then we will have to select the range of cells, for that just drag the mouse from C4 to C9

» Close the function by typing “)

Insert SUM Function to Add Specific Cells in Excel

» Right now tap the Enter button and get the result.

Insert SUM Function to Add Specific Cells in Excel

Read More: How to Sum Range of Cells in Row Using Excel VBA (6 Easy Methods)


Method 3: Apply SUMIF Function to Add Cells with Condition

Let’s apply the SUMIF function if we have to insert a specific condition.

» Type =SUMIF( then select the range by dragging the mouse from C4 to C9.

» Then press comma and set criteria. Here I have set the criteria “>1000” which means we will just add the salaries which are greater than $1000.

» Now close the function with “)”.

Apply SUMIF Function to Add Cells with Condition.

» Just now punch the Enter button.

Apply SUMIF Function to Add Cells with Condition.

Read More: Excel Sum If a Cell Contains Criteria (5 Examples)


Similar Readings


Method 4:  Use AutoSum command to Add Cells In Excel

In this section, we will add up the values by using the AutoSum command from the Formula ribbon.

» Just activate the C10 cell by pressing it

» Then press the AutoSum command from the Formula tab.

» It will select the range automatically.

Use AutoSum command to Add Cells In Excel.

» Do only one thing now, just hit the Enter button.

Use AutoSum command to Add Cells In Excel.


Method 5: Sum If Cells Contain Specific Text in Excel

To add cells based on specific text criteria we will use the SUMIF function. Here two people have the same name “Sam”. We will add just these two people’s salaries in cell C10.

» Type =SUMIF( then select the range of name by dragging the mouse from B4 to B9.

» Press comma then set the criteria by typing “*Sam*”

» Press comma again and set the sum range by dragging the mouse from C4 to C9.

» Close the function by typing “)”.

Sum If Cells Contain Specific Text in Excel.

» For result just click the Enter button now.

Sum If Cells Contain Specific Text in Excel.

Read More: Sum If a Cell Contains Text in Excel (6 Suitable Formulas)


Conclusion

I hope the procedures mentioned above will be helpful to add specific cells easily. If you have any questions or feedback please let me know in the comment section. Thank You 🙂 


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo