How to count how many times a word appears in Excel
By
SpreadCheaters
You can watch a video tutorial here.
Excel is a great tool for analyzing numerical and text data. Very often you will need to count the number of times a word appears. This could be to find the number of rows in a column with a particular value or to count the frequency with which a word appears in text data. Assume you have a sheet with thousands of sales transactions from all over the country and you need to find how many have come from a particular city. In this case, you will need to count the number of times the city name appears on the sheet.
Step 1 – Count the cells that contain only the word
– In the destination cell, type the formula:
=countif(<range of cells of the ‘City’ column>,”Chennai”)
Note: In this case, COUNTIF() can be used with just the word as the column contains cells with only the word and no other text.
Step 2 – Count the cells that contain the word with other text
– In the destination cell, type the formula:
=countif(<range of cells of the ‘City’ column>,”*great*”)
Note: In this case, asterisks (*) are placed before and after the word to indicate that it is part of other text.
Step 3 – Check the result
– The results of both types of counts are displayed
