| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countifs Text and Dates | Excel Worksheet Functions | |||
| Two COUNTIFs | Excel Discussion (Misc queries) | |||
| Countifs Fx in 07 how in 03? | Excel Discussion (Misc queries) | |||
| countifs | Excel Discussion (Misc queries) | |||
| 2 COUNTIFS | Excel Discussion (Misc queries) | |||
Threaded Mode
