How to Count multiple values within a single cell using COUNTIF Statement
Have been racking my brain on this one.
Looking to try and count the number of times a specific word is mentioned in a column, however I cannot see to capture the cells where there is multiple words added. .
I am referencing a Raw Data Sheet to a Calculation sheet, to bring back some general figures, but sadly not able to reference the multi word Cells.
Any help would be appreciated :)
Help Article Resources
Check out the Formula Handbook template!