SOLVED

Compter le nb de fois qu'un txt apparait dans un plage où les cellules contiennent plusieurs données

%3CLINGO-SUB%20id%3D%22lingo-sub-1611323%22%20slang%3D%22fr-FR%22%3ECount%20the%20nb%20of%20times%20a%20txt%20appears%20in%20a%20range%20where%20the%20cells%20contain%20multiple%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1611323%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20if%20it%20is%20possible%20to%20count%20the%20number%20of%20times%20a%20word%20(example%3A%20a%20particular%20country)%20appears%20in%20a%20range%20where%20all%20cells%20contain%20a%20list%20of%20countries.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20in%20my%20attached%20table%2C%20count%20the%20number%20of%20times%20%22France%22%20appears.%20When%20I%20try%2C%20I%20can%20only%20count%20the%20number%20of%20times%20%22France%22%20appears%20alone%20in%20a%20cell%2C%20but%20not%20when%20it%20is%20present%20with%20other%20countries.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1611323%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EBI%20-%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1611581%22%20slang%3D%22en-US%22%3ERe%3A%20Compter%20le%20nb%20de%20fois%20qu'un%20txt%20apparait%20dans%20un%20plage%20o%C3%B9%20les%20cellules%20contiennent%20plusieurs%20don%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1611581%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F770743%22%20target%3D%22_blank%22%3E%40alexpiv%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20the%20solution%3C%2FP%3E%3CP%3Eyou%20use%20find%2C%20then%20find%20returns%20a%20result%20you%20search%20starting%20from%20the%20next%20character%3C%2FP%3E%3CP%3Ethis%20formula%20will%20count%20until%206%20words%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20it%20is%20fine%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612069%22%20slang%3D%22en-US%22%3ERe%3A%20Compter%20le%20nb%20de%20fois%20qu'un%20txt%20apparait%20dans%20un%20plage%20o%C3%B9%20les%20cellules%20contiennent%20plusieurs%20don%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F770743%22%20target%3D%22_blank%22%3E%40alexpiv%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20count%20for%20entire%20column%2C%20not%20for%20each%20record%20separately%2C%20when%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20292px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214705i460650180A0625DF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTIF(A%3AA%2C%20%22*%22%26amp%3BC1%26amp%3B%22*%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour,

Je souhaiterai savoir s'il est possible de compter le nombre de fois où un mot (exemple: un pays en particulier) apparaît dans une plage où toutes les cellules contiennent une liste de pays. 

 

Par exemple dans mon tableau ci-joint, compter le nombre de fois où "France" apparaît. Lorsque j'essaie, je ne peux compter que le nombre de fois où "France" apparait seul dans une cellule, mais pas lorsqu'il est présent avec d'autres pays. 

 

Merci d'avance

2 Replies

@alexpiv 

Please find the solution

you use find, then find returns a result you search starting from the next character

this formula will count until 6 words

 

hope it is fine

Best Response confirmed by alexpiv (Occasional Visitor)
Solution

@alexpiv 

If count for entire column, not for each record separately, when

image.png

=COUNTIF(A:A, "*"&C1&"*")