Hi! trying to count how many times a value appears in a range, but I'm stuck because I can't figure out how to count it if it repeats in a cell.
Example: How do I calculate how many times the word apple appears below:
The answer should be 5 but I can't figure it out, thank you in advance for the help!
Example: How do I calculate how many times the word apple appears below:
Location | 5/1/2020 | 5/2/2020 | 5/3/2020 |
1 | apple | apple, oranges | apple, apple |
2 | banana | peach, apple | orange |
The answer should be 5 but I can't figure it out, thank you in advance for the help!