To count cells that contain at least a certain word or entry in Microsoft Excel, follow these steps:
- Select the cell where you want to display the result of the count.
- Type the following formula: =COUNTIF(range,"*word*")
Replace "range" with the range of cells you want to count, and replace "word" with the word or entry you want to count.
For example, to count cells that contain "he" or "she" in the range A1:A3, you would type: =COUNTIF(A1:A3,"*he*")+COUNTIF(A1:A3,"*she*")
To count cells that contain "it" in the same range, you would type: =COUNTIF(A1:A3,"*it*") - Press Enter to display the result.
The
COUNTIF function counts the number of cells in the specified range that meet the specified criteria. The asterisks (*) are used as wildcards to match any number of characters before or after the word or entry you want to count. By using the plus sign (+) between two
COUNTIF functions, you can count cells that contain either of the two words or entries.