If Cell Contains Specific Text Then Add 1 in Excel (5 Examples)

Whenever you want to search for any specific text to do some operations you can easily do it in Excel. In this article, I’m going to show you in Excel that if a cell contains specific text then add 1.

To make the explanation clearer, I’m going to use a sample dataset that represents information about a particular employer regarding salary and rank. The dataset contains 4 columns: Employee Name, Rank, and Salary.

If Cell Contains Specific Text Then Add 1 in Excel: 5 Examples

1. Using IF Function to Add 1 If Cell Contains Specific Text

By using the IF function you can easily find out if the cell contains any specific text or not then you can add 1 by simply using the arguments of the IF function.

Steps:

To begin with,

• First, select any cell of your choice to place your resultant value.
• Here, I’ve selected cell E5.
• Then, type the following formula in cell E5 or into the Formula Bar.

Here, in the IF function, I used a condition in the logical_test to check if the cell contains the specific text “Adam Smith” if it does then it will add 1 to the Rank of that particular employee otherwise Rank will remain as it is.

• Now, press ENTER to add 1 if the cell contains the specific text, Adam Smith.

• Here, you can use the Fill Handle to AutoFill formula for the rest of the cells.

2. Combining IF & ISTEXT Functions to Add 1 If Cell Contains Specific Text

You also can use the combination of IF and ISTEXT functions to add 1 if the cells contain specific text.

Steps:

To start with,

• First, select any cell of your choice to place your resultant value.
• Here, I’ve selected cell E5.
• Then, type the following formula in cell E5 or into the Formula Bar.

Here, the ISTEXT function will check whether the cell value is text or number. Then, the IF function will check the logical_test and If the cell value of the B5 cell is text then it will add 1 to the cell value of C5 to Upgrade the Rank. Otherwise, the Rank will remain as before.

• Finally, press ENTER to add 1 if the cell contains the specific texts.

• Now, you can use the Fill Handle to AutoFill formula for the rest of the cells.

3. Employing IF & COUNTIF Functions to Add 1 If Cell Contains Specific Text

If you want, you also can use the combination of IF and COUNTIF functions to add 1 if the cells contain specific text.

Steps:

To start with,

• First, select any cell of your choice to place your resultant value.
• Here, I’ve selected cell E5.
• Then, type the following formula in cell E5 or into the Formula Bar.

• Now, press ENTER to get the result.

• Here, you can use the Fill Handle to AutoFill formula for the rest of the cells.

4. Using SUM & IF Functions to Add 1 If Cell Contains Specific Text

Here, I’m going to use the combination of IF and SUM functions to add 1 if the cells contain specific text.

Steps:

To start with,

• First, select any cell of your choice to place your resultant value.
• Here, I’ve selected cell F6.
• Then, type the following formula in cell F6 or into the Formula Bar.

Here, the IF function will search the specific text Adam Smith within the range B5:B12 then it will Add 1 for each match through the SUM function.

• Now, press ENTER to get the resultant value.

5. Using Combined Functions to Add 1 If Cell Contains Specific Text

In case you want to check multiple specific texts then you can use the IF function, the OR function, and the COUNTIF function to add 1.

Here, I’m going to use two specific texts these are Adam and Kate.

Steps:

To begin with,

• First, select any cell of your choice to place your resultant value.
• Here, I’ve selected cell E5.
• Then, type the following formula in cell E5 or into the Formula Bar.

• Press ENTER to add 1 if the cell contains specific text.

• Here, you can use the Fill Handle to AutoFill formula for the rest of the cells.

Practice Section

You can practice the explained methods in the practice section.

Download Practice Workbook

Conclusion

In this article, I have shown 5 methods of Excel if the cell contains specific text then add 1. These ways will help you to simplify your task. Feel free to comment down below for any types of queries and suggestions.

<< Go Back to Text | If Cell Contains | Formula List | Learn Excel