JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,532
- Office Version
- 365
- Platform
- Windows
I know CountIf can count the number of occurrences of a word in a range if each call in that range contains only a single word. Is there a formula that can count the number of occurrences of a word in a range where each cell may contains multiple words?
In this table, I would like the "house" count to be "3".
<tbody>
</tbody>
Thanks
In this table, I would like the "house" count to be "3".
R/C | C | D | E |
4 | house | 1 | D4: =COUNTIF($C$4:$C$7,"house") |
5 | dog | 1 | D5: =COUNTIF($C$4:$C$7,"dog") |
6 | house dog | 0 | D6: =COUNTIF($C$4:$C$7,"cat") |
7 | cat house |
<tbody>
</tbody>
Thanks