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.

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

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 “)”

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

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 “)”.

» Just now punch the Enter button.

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

Similar Readings

• How to Use VLOOKUP with SUM Function in Excel (6 Methods)
• Sum Cells in Excel: Continuous, Random, With Criteria, etc.
• How to Sum Cells with Text and Numbers in Excel (2 Easy Ways)
• Sum to End of a Column in Excel (8 Handy Methods)
• How to Sum Multiple Rows and Columns in Excel

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.

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

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 “)”.

» For result just click the Enter button now.

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

• How to Sum Only Visible Cells in Excel (4 Quick Ways)
• [Fixed!] Excel SUM Formula Is Not Working and Returns 0 (3 Solutions)
• How to Sum Selected Cells in Excel (4 Easy Methods)
• Sum by Font Color in Excel (2 Effective Ways)
• Sum Filtered Cells in Excel (5 Suitable Ways)
• How to Sum Colored Cells in Excel (4 Ways)