How to count multiple values in a cell within a range?
I am trying to figure out a formula where I can count 1 row more than once in a COUNTIF formula based on what it contains. For example, I have a column that includes multiple values, separated by commas. I'd like to be able to count the total number of commas within that cell. For example, if a cell has three commas - it is counted three times rather than just once in a COUNT IF formula.
Hope this makes sense and open to any and all feedback! Hoping to do this without helper columns.
Help Article Resources
Check out the Formula Handbook template!