| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countifs on TEXT
Text cells being in A1:A4, list of names in C1:C3, enter this formula in D1
and copy down to D3! =SUMPRODUCT(--(NOT(ISERROR(SEARCH(C3,$A$1:$A$4)))),--(NOT(ISERROR(SEARCH("happy",$A$1:$A$4))))) Adjust ranges to real table. It is case insensitive, if you need a case sensitive search replace SEARCH by FIND function! Regards, Stefi €˛ycwkpp898€¯ ezt Ć*rta: 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 |
| Reply |
| 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) | |||
Hybrid Mode
