Excel Formulas to Count the Specific Keywords in the Cell ~ Easily!!
Tags: excelformula, excelformulas
Published: 2021-06-16 12:01:58

---
title: Excel Formulas to Count the Specific Keywords in the Cell ~ Easily!!
published: true
date: 2021-06-04 09:50:18 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-the-specific-keywords-in-the-cell/
---

Excel allows a user to count keywords that a cell contains using the [**SUMPRODUCT**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/),[**ISNUMBER**](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/), and [**SEARCH**](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)functions. This step-by-step tutorial will assist all levels of Excel users to **count the specific keywords the cell contains**. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

![Count specific keywords](https://geekexcel.com/wp-content/uploads/2021/06/Count-specific-keywords-.png)<figcaption id="caption-attachment-46063">Count specific keywords</figcaption>

## Generic Formula:

- You can use the below formula to count the number of specific words or keywords that appear in a given cell.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–[ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)([SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)(keywords,A1)))**

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, the [**SUMPRODUCT function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/) helps to repeat characters a given number of times.
- **ISNUMBER** – This function helps to return TRUE when a cell contains a number, and FALSE if there will not be a number. Read more on the **[ISNUMBER Function](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)**.
- **SEARCH** – The Excel **[SEARCH function](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)** locates the character between two text strings and returns to the number of the starting position of the first text string from the first character of the second text string.
- **Keywords** – It specifies the keywords that you need to check.
- **A1** – It represents the input values.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Refer to the below example image.

- Here, we will enter the input values in **Column B**.
- Now we need to count the specific keywords given in **Column E**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-9.png)<figcaption id="caption-attachment-46061">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-13.png)<figcaption id="caption-attachment-46064">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-12.png)<figcaption id="caption-attachment-46062">Result</figcaption>

## Verdict:

Hope you like this article on how to **count the specific keywords in a cell in Excel**. Please feel free to state your **query** or **feedback** for the above article.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[Excel Formulas Check the Cell Contains Some Words but Not Others!!](https://geekexcel.com/excel-formulas-check-the-cell-contains-some-words-but-not-others/)**
- **[{Tricks} Excel Formulas to Combine Text And Date Into Same Cell!!](https://geekexcel.com/excel-formulas-to-combine-text-and-date/)**
- **[Excel Formulas to Generate a Series of Dates by Custom Days ~ Easily!!](https://geekexcel.com/excel-formulas-to-generate-a-series-of-dates-by-custom-days/)**