I have a column of cells in which there are some numbers and some words. I need to know how to get Excel to count how many times a certain word appears .
I have a column of cells in which there are some numbers and some words. I need to know how to get Excel to count how many times a certain word appears .
Last edited by davidcrawt; 07-05-2017 at 06:33 AM.
What happens if the word appears more than once in the same cell?
Do you want an indicator that the word appears in that cell or the total number of occurrences in that cell?
Your description is therefore not clear enough so please provide some sample data with expected results.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
OK, I have a column of cells. Some of them have numbers in them and some have the word 'Oyster'. I want a formula which tells me have many cells in the range have the word 'Oyster' in them.
TRY
=COUNTIF(A1:A100,"*Oyster*")
OR
=COUNTIF(A1:A100,"Oyster")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
It's OK, I have now worked it out myself. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks