I need to count the number of times a word appears in a series of cells.
I currently use =COUNTIF($B$2:$B$5,"*drama*") but have to change "drama" everytime to something else like "english". Is there an easir way to do this? Have pasted an example below and. Thanks you
I currently use =COUNTIF($B$2:$B$5,"*drama*") but have to change "drama" everytime to something else like "english". Is there an easir way to do this? Have pasted an example below and. Thanks you
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
2 | Drama/English/LOTE/Library/Maths/Music/TAS/IndividualpreparationtimeHSIE/LearningSupport/PDHPE/Science/VisArts/Individualpreparationtime | |||||
3 | Drama/English/LOTE/Library/Maths/Music/TAS/IndividualpreparationtimeHSIE/LearningSupport/PDHPE/Science/VisArts/Individualpreparationtime | |||||
4 | Drama/English/LOTE/Library/Maths/Music/TAS/IndividualpreparationtimeHSIE/LearningSupport/PDHPE/Science/VisArts/Individualpreparationtime | |||||
5 | Drama/English/LOTE/Library/Maths/Music/TAS/IndividualpreparationtimeHSIE/LearningSupport/PDHPE/Science/VisArts/Individualpreparationtime | |||||
6 | ||||||
7 | Drama | 0 | 4 | |||
Sheet1 |