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.
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.
- 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.
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 🙂
- 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)