Excel Formulas to Count the Specific Keywords in the Cell ~ Easily!!

Excel allows a user to count keywords that a cell contains using the SUMPRODUCT,ISNUMBER, and SEARCHfunctions. 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

Generic Formula:

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

=SUMPRODUCT(–ISNUMBER(SEARCH(keywords,A1)))

Syntax Explanations:

  • SUMPRODUCT – In Excel, the SUMPRODUCT function 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.
  • SEARCH – The Excel SEARCH function 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.
  • Select any cell and type the above-given formula.
  • Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

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!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Ahead:

13