Countifs on TEXT
hi i need to do a countifs to tell me how many times someone said Happy (
sometime they will put something like bob says: Happy chappy
Bob says: Happy
George says: Sad
Bob says: Happy man
Helen says: Happyyyyyyyyyy
each name and writing is in one cell
I want it to go to each name and put next to there name the amount of times
they said Happy i have tried the following
=IF(F4=""," ",COUNTIFS(alias_played,F4,who_played,"=Happy "))
also how can i put so if some people put Happy, HAPPY, Happyyyyyyyyy
|