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

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

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

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

## 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

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